# Data Dictionary Items Service Desk

### 26/03/10 17:26

Address (table: itsm_addresses properties: only detail)

Description | Column | Related to
--- | --- | ---
Address type, The address type specifies the intended use of the address. For example, business e-mail should be sent to a business type address. (Reference to Address type, Number 18) | adr_typ_oid | itsm_codes
City, City name. (Text 50) | adr_city |
Country/Region, Country or region name. (Text 50) | adr_countryregion |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | adr_oid |
Organization (Reference to Organization, Number 18) | adr_org_oid | itsm_organizations
Person (Reference to Person, Number 18) | adr_per_oid | itsm_persons
State/Province, State or province name. (Text 50) | adr_stateprovince |
Street1, Street name and house number. Can also be used as postbox and postbox number. (Text 50) | adr_street1 |
Street2, Street name and house number. (Text 50) | adr_street2 |
Template (Reference to Template, Number 18) | adr_tem_oid | rep_templates
Zip/Postal code, Zip code or postal code. (Text 50) | adr_zippostalcode |

Address type (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Analyzed data Change (table: itsm_analyzed_data properties: only detail, code, authorizable)

Description | Column | Related to
--- | --- | ---
Assigned from Person (Reference to Person, Number 18) | agd_person_from_oid | itsm_persons
Assigned from Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_from_oid | itsm_workgroups
Assigned to Person (Reference to Person, Number 18) | agd_person_to_oid | itsm_persons
Assigned to Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_to_oid | itsm_workgroups
Change (Reference to Change, Number 18) | agd_cha_oid | itsm_changes
Date from (Date) | agd_datefrom |
Date to (Date) | agd_dateto |
Duration (Number 9) | agd_duration |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Item (Text 255) | agd_item |
Object ID (Object ID, Number 18) | agd_oid |
Report Type (Reference to Report Type, Number 18) | agd_report_oid | itsm_codes
Status from (Reference to Status, Number 18) | agd_status_from_oid | rep_codes
Status to (Reference to Status, Number 18) | agd_status_to_oid | rep_codes
Subject (Text 255) | agd_subject |
Template (Reference to Template, Number 18) | agd_tem_oid | rep_templates

Analyzed data Incident (table: itsm_analyzed_data properties: only detail, code, authorizable)

Description | Column | Related to
--- | --- | ---
Assigned from Person (Reference to Person, Number 18) | agd_person_from_oid | itsm_persons
Assigned from Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_from_oid | itsm_workgroups
Assigned to Person (Reference to Person, Number 18) | agd_person_to_oid | itsm_persons
Assigned to Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_to_oid | itsm_workgroups
Date from (Date) | agd_datefrom |
Date to (Date) | agd_dateto |
Duration (Number 9) | agd_duration |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Incident (Reference to Incident, Number 18) | agd_inc_oid | itsm_incidents
Item (Text 255) | agd_item |
Object ID (Object ID, Number 18) | agd_oid |
Report Type (Reference to Report Type, Number 18) | agd_report_oid | itsm_codes
Status from (Reference to Status, Number 18) | agd_status_from_oid | rep_codes
Status to (Reference to Status, Number 18) | agd_status_to_oid | rep_codes
Subject (Text 255) | agd_subject |
Template (Reference to Template, Number 18) | agd_tem_oid | rep_templates

Analyzed data Problem (table: itsm_analyzed_data properties: only detail, code, authorizable)

Description | Column | Related to
--- | --- | ---
Assigned from Person (Reference to Person, Number 18) | agd_person_from_oid | itsm_persons
Assigned from Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_from_oid | itsm_workgroups
Assigned to Person (Reference to Person, Number 18) | agd_person_to_oid | itsm_persons
Assigned to Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_to_oid | itsm_workgroups
Date from (Date) | agd_datefrom |
Date to (Date) | agd_dateto |
Duration (Number 9) | agd_duration |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Item (Text 255) | agd_item |
Object ID (Object ID, Number 18) | agd_oid |
Problem (Reference to Problem, Number 18) | agd_pro_oid | itsm_problems
Report Type (Reference to Report Type, Number 18) | agd_report_oid | itsm_codes
Status from (Reference to Status, Number 18) | agd_status_from_oid | rep_codes
Status to (Reference to Status, Number 18) | agd_status_to_oid | rep_codes
Subject (Text 255) | agd_subject |
Template (Reference to Template, Number 18) | agd_tem_oid | rep_templates

Analyzed data Project (table: itsm_analyzed_data properties: only detail, code, authorizable)

Description | Column | Related to
--- | --- | ---
Assigned from Person (Reference to Person, Number 18) | agd_person_from_oid | itsm_persons
Assigned from Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_from_oid | itsm_workgroups
Assigned to Person (Reference to Person, Number 18) | agd_person_to_oid | itsm_persons
Assigned to Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_to_oid | itsm_workgroups
Date from (Date) | agd_datefrom |
Date to (Date) | agd_dateto |
Duration (Number 9) | agd_duration |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Item (Text 255) | agd_item |
Object ID (Object ID, Number 18) | agd_oid |
Project (Reference to Project, Number 18) | agd_prj_oid | itsm_projects
Report Type (Reference to Report Type, Number 18) | agd_report_oid | itsm_codes
Status from (Reference to Status, Number 18) | agd_status_from_oid | rep_codes
Status to (Reference to Status, Number 18) | agd_status_to_oid | rep_codes
Subject (Text 255) | agd_subject |
Template (Reference to Template, Number 18) | agd_tem_oid | rep_templates

Analyzed data Service call (table: itsm_analyzed_data properties: only detail, code, authorizable)

Description | Column | Related to
--- | --- | ---
Assigned from Person (Reference to Person, Number 18) | agd_person_from_oid | itsm_persons
Assigned from Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_from_oid | itsm_workgroups
Assigned to Person (Reference to Person, Number 18) | agd_person_to_oid | itsm_persons
Assigned to Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_to_oid | itsm_workgroups
Date from (Date) | agd_datefrom |
Date to (Date) | agd_dateto |
Duration (Number 9) | agd_duration |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Item (Text 255) | agd_item |
Object ID (Object ID, Number 18) | agd_oid |
Report Type (Reference to Report Type, Number 18) | agd_report_oid | itsm_codes
Service call (Reference to Service call, Number 18) | agd_ser_oid | itsm_servicecalls
Status from (Reference to Status, Number 18) | agd_status_from_oid | rep_codes
Status to (Reference to Status, Number 18) | agd_status_to_oid | rep_codes
Subject (Text 255) | agd_subject |
Template (Reference to Template, Number 18) | agd_tem_oid | rep_templates

Analyzed data Workorder (table: itsm_analyzed_data properties: only detail, code, authorizable)

Description | Column | Related to
--- | --- | ---
Assigned from Person (Reference to Person, Number 18) | agd_person_from_oid | itsm_persons
Assigned from Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_from_oid | itsm_workgroups
Assigned to Person (Reference to Person, Number 18) | agd_person_to_oid | itsm_persons
Assigned to Workgroup (Reference to Workgroup, Number 18) | agd_workgroup_to_oid | itsm_workgroups
Date from (Date) | agd_datefrom |
Date to (Date) | agd_dateto |
Duration (Number 9) | agd_duration |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Item (Text 255) | agd_item |
Object ID (Object ID, Number 18) | agd_oid |
Report Type (Reference to Report Type, Number 18) | agd_report_oid | itsm_codes
Status from (Reference to Status, Number 18) | agd_status_from_oid | rep_codes
Status to (Reference to Status, Number 18) | agd_status_to_oid | rep_codes
Subject (Text 255) | agd_subject |
Template (Reference to Template, Number 18) | agd_tem_oid | rep_templates
Work order (Reference to Work order, Number 18) | agd_wor_oid | itsm_workorders

Approval properties: only detail)

Description | Column | Related to
--- | --- | ---
#Approved approvers (Number 9) |  |
#Approvers Required, The number of approvers who need to approve to get approval for this item. (Number 9) |  |
Approval group, Workgroup of the approvers (Reference to Workgroup, Number 18) |  |
Approval Status, The status of the approval. Only at status Active it possible to vote for approval (Reference to Approval Status, Number 18) |  |
Approval Votes, People responsible for voting for approval (Set of Approval Vote) |  | itsm_approver_votes apv_apt_oid
Deadline, The deadline which before all approvers have to vote. If the deadline is passed and the approval result is still incomplete the result will be set to Rejected (Date) |  |
Description, Approval Description (Text 80) |  |
NrOfApprovers (Number 9) |  |
Result, This field reflects the state of the approval for this item (Text 40) |  |
Strategy, The used strategy for this approval (Text 255) |  |

Approval Status (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
IsActiveStatus (Boolean, Number 1) | cod_isactivestatus |
IsInactiveStatus (Boolean, Number 1) | cod_isinactivestatus |
IsReadyStatus (Boolean, Number 1) | cod_isreadystatus |
Object ID (Object ID, Number 18) | cod_oid |
Ordering, Ordering number for the current code. The lower the number the higher the code will be shown in lists. Once a code is used, do not modify the number. (Number 9) | cod_ordering |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Approval Vote (table: itsm_approver_votes properties: only detail)

Description | Column | Related to
--- | --- | ---
Approval (Reference to Approval, Number 18) | apv_apt_oid |
Approved, Approved list box. Select Yes to vote for approval, select No to vote against approval for this item (Boolean, Number 1) | apv_approved |
Approver, Person who can vote for approval (Reference to Person, Number 18) | apv_per_oid | itsm_persons
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | apv_oid |
Reason, Reason for voting for or against approval . Required if voted against approval (Text 255) | apv_reason |
Template (Reference to Template, Number 18) | apv_tem_oid | rep_templates

Assignment properties: only detail)

Description | Column | Related to
--- | --- | ---
Assignment Priority, Priority of assignment The priority shows the importance of quick handling of the assignment. The higher the priority, the faster the assignment must be addressed. (Reference to Assignment Priority, Number 18) |  |
Assignment Status, The status shows the progress of the responsible person's work towards completion. (Reference to Assignment Status, Number 18) |  |
External Deadline, The latest date the external organization is expected to complete and deliver work they are made responsible for . (Date) |  |
From person, Person who created the current assignment. This person assigned the current item to another person. (Reference to Person, Number 18) |  |
From workgroup, The workgroup of the person who created the current assignment. (Reference to Workgroup, Number 18) |  |
Information from sender, From this field the receiver of the service call can review additional information about the service call that was added by the sender (Text 4000) |  |
Information to receiver, In this field the sender who assigns the service call to a receiver can add information about the background of the service call, some additional information, and why it is sent to this receiver (Text 4000) |  |
Reference #, Reference number used to communicate information with the responsible external organization. (Text 50) |  |
To external Organization, External organization responsible for handling the item. (Reference to Organization, Number 18) |  |
To external Person, Employee of the external organization responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) |  |
To person, Person made responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) |  |
To workgroup, Work group of the person currently responsible for this item. (Reference to Workgroup, Number 18) |  |

Assignment Priority (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Ordering, Ordering number for the current code. The lower the number the higher the code will be shown in lists. Once a code is used, do not modify the number. (Number 9) | cod_ordering |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Assignment Status (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Closed, Closed check box. When checked, the current assignment status is a closed status. When an assignment has a closed status, no work is performed on the assignment. (Boolean, Number 1) | cod_assignmentclosed |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
New, New status check box. If selected, the current status is the new status. (Boolean, Number 1) | cod_assignmentnew |
Object ID (Object ID, Number 18) | cod_oid |
Ordering, Ordering number for the current code. The lower the number the higher the code will be shown in lists. Once a code is used, do not modify the number. (Number 9) | cod_ordering |
Read, Read status check box. If selected, the current assignment status is the read status. The status of an assignment is turned to Read after a new assignment is opened by the receiver. (Boolean, Number 1) | cod_assignmentread |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Brand (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Change (table: itsm_changes properties: authorizable)

Description | Column | Related to
--- | --- | ---
Actual Cost, The actual costs of handling this item. (Number 64) | cha_actualcost |
Actual Duration, Total time worked on this item. (Number 9) | cha_actualduration |
Actual Finish, The date work on this item finished. (Date) | cha_actualfinish |
Actual Start, The date working on this item was started. (Date) | cha_actualstart |
Analyzed data Change (Set of Analyzed data Change) |  | itsm_analyzed_data agd_cha_oid
#Approved approvers (Number 9) | cha_apt_nrofapproversapproved |
#Approvers Required, The number of approvers who need to approve to get approval for this item. (Number 9) | cha_apt_nrofapproversrequired |
Approval group, Workgroup of the approvers (Reference to Workgroup, Number 18) | cha_apt_wog_oid | itsm_workgroups
Approval Status, The status of the approval. Only at status Active it possible to vote for approval (Reference to Approval Status, Number 18) | cha_apt_status | itsm_codes
Approval Votes, People responsible for voting for approval (Set of Approval Vote) |  | itsm_approver_votes apv_apt_oid
Deadline, The deadline which before all approvers have to vote. If the deadline is passed and the approval result is still incomplete the result will be set to Rejected (Date) | cha_apt_deadline |
Description, Approval Description (Text 80) | cha_apt_description |
NrOfApprovers (Number 9) | cha_apt_nrofapprovers |
Result, This field reflects the state of the approval for this item (Text 40) |  |
Strategy, The used strategy for this approval (Text 255) |  |
Assignment Priority, Priority of assignment The priority shows the importance of quick handling of the assignment. The higher the priority, the faster the assignment must be addressed. (Reference to Assignment Priority, Number 18) | cha_assign_priority | itsm_codes
Assignment Status, The status shows the progress of the responsible person's work towards completion. (Reference to Assignment Status, Number 18) | cha_assign_status | itsm_codes
External Deadline, The latest date the external organization is expected to complete and deliver work they are made responsible for . (Date) | cha_assign_extdeadline |
From person, Person who created the current assignment. This person assigned the current item to another person. (Reference to Person, Number 18) | ass_per_from_oid | itsm_persons
From workgroup, The workgroup of the person who created the current assignment. (Reference to Workgroup, Number 18) | ass_wog_from_oid | itsm_workgroups
Information from sender, From this field the receiver of the service call can review additional information about the service call that was added by the sender (Text 4000) | itsm_cha_ass_information cas_ass_information |
Information to receiver, In this field the sender who assigns the service call to a receiver can add information about the background of the service call, some additional information, and why it is sent to this receiver (Text 4000) |  |
Reference #, Reference number used to communicate information with the responsible external organization. (Text 50) | cha_assign_referencenumber |
To external Organization, External organization responsible for handling the item. (Reference to Organization, Number 18) | ass_contr_out_org | itsm_organizations
To external Person, Employee of the external organization responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | ass_contr_out_per | itsm_persons
To person, Person made responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | ass_per_to_oid | itsm_persons
To workgroup, Work group of the person currently responsible for this item. (Reference to Workgroup, Number 18) | ass_wog_oid | itsm_workgroups
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | cha_attachment_exists |
Category, The change's category. The category groups changes in a hierarchical structure. In this structure changes are grouped based on the type of change. Click Category and select a category from the tree view. (Reference to Change Category, Number 18) | cha_cat_oid | rep_codes
Category (Service Today) (Reference to Category, Number 18) | cha_cat_oid | rep_codes
Classification, Classification reflects an assessment of the change after implementation. Click Classification and select a classification code from the tree view. (Reference to Change Classification, Number 18) | cha_cla_oid | itsm_codes
Closure code, The closure code shows the reason why the status of the change is closed or not worked on anymore. (Reference to Change closure code, Number 18) | cha_closurecode | itsm_codes
Configuration Item, The configuration item that is subject of the current item. (Reference to Configuration Item, Number 18) | cha_cit_oid | itsm_configuration_items
Deadline, The latest date the results and work related to this item must be completed and delivered. (Date) | cha_deadline |
Description, Description of current item. The description 's a summary of the information field. The description is used for later retrieval and analyses. (Text 80) | cha_description |
Early finish, The earliest date planned that work on this item will be finalized. (Date) | cha_earlyfinish |
Early start, The earliest date planned that working on this item will start. (Date) | cha_earlystart |
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | cha_per_oid | itsm_persons
Estimated finish, Date and time that the item is expected to be finished. (Date) |  |
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | cha_poo_oid | rep_codes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, List of history lines. With the history lines you can track the modifications to this item. What modifications are tracked is set by the system administrator. (Set of History line Change) |  | itsm_historylines_change hch_cha_oid
ID, Identification number. Used to identify the item when communicating information about the item. (ID, Number 18) | cha_id |
Impact, The impact reflects how much the work of the caller is impaired or in what extent the work of other people is impaired. (Reference to Impact, Number 18) | cha_imp_oid | itsm_codes
Information, Full information of this item. Should contain all necessary information needed to handle the item or work on the item. (Text 4000) | itsm_cha_information chi_information |
Initiator, The person who is responsible for initiating approval for this item. (Reference to Person, Number 18) | cha_initiator_per_oid | itsm_persons
Late finish, The latest date planned to finalize work on this item. (Date) | cha_latefinish |
Late start, The latest date planned to start work on this item. (Date) | cha_latestart |
Manager (Reference to Person, Number 18) | cha_per_man_oid | itsm_persons
Max. duration, Maximum amount of time allowed for working on the current item. (Number 9) | cha_maximumduration |
Object ID (Object ID, Number 18) | cha_oid |
Open duration, Actual time the current item is opened. (Number 9) |  |
Planned Cost, Planned total cost of handling this item. (Number 64) | cha_plannedcost |
Planned Duration, Planned duration of work on this item. (Number 9) | cha_planduration |
Planned Finish, Date planned to finalize work on this item. (Date) | cha_planfinish |
Planned Start, Planned date to start working on this item. (Date) | cha_planstart |
Predecessor, Change that has time dependencies with successor change(s). (Set of Change Predecessor) |  | itsm_change_predecessors cpd_successor_cha_oid
Priority, The priority reflects the urgency for quick resolution of the item. (Reference to Priority, Number 18) | cha_pri_oid | itsm_codes
Project, Project that includes current change. (Reference to Project, Number 18) | cha_prj_oid | itsm_projects
Registered, Date and time the current item was created. (Date) |  |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Relations, List of items related to this change. (Set of Service Event Relation) |  | itsm_service_relations sre_cha_oid
Remain duration, Remaining duration of work on this item, calculated from the current date to the planned finish date. (Number 9) | cha_remainduration |
Requestor, The person who requested this item. This person is excluded from voting for approval for this item. (Reference to Person, Number 18) | cha_requestor_per_oid | itsm_persons
Solution, Proposed or accepted and working final result of the change. (Text 255) | cha_solution |
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | cha_sourceid |
Status, Status of this change. Shows the position of the change in its lifecycle. The lifecycle of a change starts with being created and ends with being removed. (Reference to Change Status, Number 18) | cha_sta_oid | rep_codes
Status (Service Today) (Reference to Status, Number 18) | cha_sta_oid | rep_codes
Successor (Set of Change Predecessor) |  | itsm_change_predecessors cpd_predecessor_cha_oid
Template (Reference to Template, Number 18) | cha_tem_oid | rep_templates
To deadline, Amount of time till deadline is reached (Number 9) |  |
Wait for Work Order Completion (Boolean, Number 1) | cha_waitforwo |
Workaround, Proposed and working workaround to prevent or take away problems resulting from the not implemented change or the change in progress. (Text 255) | cha_workaround |
Work orders, List of work orders related to this change. New to relate a new work order. Relate to relate an existing work order. Select a work order and click Modify to open the selected work order.\\ Unrelate to remove the selected work order from the list. (Set of Work order) |  | itsm_workorders wor_cha_oid

Change Category (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Attributes (Set of Attributes per category) |  | rep_attr_per_category apc_cat_oid
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Children, List of children for this code. (Set of Kernel Code Hierarchical) |  | rep_codes rcd_rcd_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Kernel Code Hierarchical, Number 18) | rcd_rcd_oid | rep_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Change Classification (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Children, List of children for this code. (Set of Code hierarchical) |  | itsm_codes cod_cod_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Code hierarchical, Number 18) | cod_cod_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Change closure code (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Children, List of children for this code. (Set of Code hierarchical) |  | itsm_codes cod_cod_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Code hierarchical, Number 18) | cod_cod_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Change Predecessor (table: itsm_change_predecessors properties: only detail)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | cpd_oid |
Predecessor, Change that has time dependencies with successor change(s). (Reference to Change, Number 18) | cpd_predecessor_cha_oid | itsm_changes
Successor, Change that has time dependencies with predecessor change(s). (Reference to Change, Number 18) | cpd_successor_cha_oid | itsm_changes
Template (Reference to Template, Number 18) | cpd_tem_oid | rep_templates

Change Status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
State (Reference to State, Number 18) | itsm_workflow_statuses wos_sta_oid | itsm_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

CI Category (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Attributes (Set of Attributes per category) |  | rep_attr_per_category apc_cat_oid
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Children, List of children for this code. (Set of Kernel Code Hierarchical) |  | rep_codes rcd_rcd_oid
Configuration items (Set of Configuration Item) |  | itsm_configuration_items cit_cat_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Kernel Code Hierarchical, Number 18) | rcd_rcd_oid | rep_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

CI Component (table: itsm_cicomponents properties: only detail)

Description | Column | Related to
--- | --- | ---
CI Child (Reference to Configuration Item, Number 18) | cic_cita_oid | itsm_configuration_items
CI Parent (Reference to Configuration Item, Number 18) | cic_citb_oid | itsm_configuration_items
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | cic_oid |
Template (Reference to Template, Number 18) | cic_tem_oid | rep_templates

CI Organization (table: itsm_ci_orgs properties: only detail)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | cio_oid |
Template (Reference to Template, Number 18) | cio_tem_oid | rep_templates
To Configuration Item (Reference to Configuration Item, Number 18) | cio_cit_oid | itsm_configuration_items
ToOrganization (Reference to Organization, Number 18) | cio_org_oid | itsm_organizations

CI relation (table: itsm_ci_relations properties: only detail)

Description | Column | Related to
--- | --- | ---
CI from, The current configuration item. You are creating a relation from the current configuration item to another configuration item. (Reference to Configuration Item, Number 18) | cir_cifrom_oid | itsm_configuration_items
CI relation type, Relation type of the relation between configuration items. Select a relation type from the list. (Reference to CI relation type, Number 18) | cir_rty_oid | itsm_codes
CI to, Use the lookup item button to select a configuration item you want to relate to the current configuration item. (Reference to Configuration Item, Number 18) | cir_cito_oid | itsm_configuration_items
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | cir_oid |
Template (Reference to Template, Number 18) | cir_tem_oid | rep_templates

CI relation type (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Ordering, Ordering number for the current code. The lower the number the higher the code will be shown in lists. Once a code is used, do not modify the number. (Number 9) | cod_ordering |
Reverse Relation, Relation type used when the relation is viewed from the related item. (Reference to Relation type, Number 18) | cod_reverse_rel_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

CI Status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

CI User (table: itsm_ci_users properties: only detail)

Description | Column | Related to
--- | --- | ---
Configuration Item (Reference to Configuration Item, Number 18) | ciu_cit_oid | itsm_configuration_items
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | ciu_oid |
Template (Reference to Template, Number 18) | ciu_tem_oid | rep_templates
User, The user of the configuration item. Use the lookup item button to find a user or to create a new user. (Reference to Person, Number 18) | ciu_user_per_oid | itsm_persons

Classification Checklist (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Classifications (Set of Service call Classification) |  | itsm_codes cod_checklist_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Questions (Set of Question) |  | itsm_checklist_questions cqu_cod_oid
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Code Text (table: itsm_codes_locale properties: only detail, code)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Language (Reference to Language, Number 18) | cdl_lng_oid | rep_locales
Localizable item, Localizable item (Reference to Localizable item, Number 18) | cdl_cod_oid | itsm_codes
Object ID (Object ID, Number 18) | cdl_oid |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | cdl_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | cdl_created_by_acc_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | cdl_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | cdl_modified_by_acc_oid | rep_accounts
Revised, Revised check box. Select or clear this check box to show you edited the current item. (Boolean, Number 1) | cdl_revised |
Status, Status field (Reference to Text Status, Number 18) | cdl_ats_oid | rep_appl_text_status
Template (Reference to Template, Number 18) | cdl_tem_oid | rep_templates
Text (Text 255) | cdl_name |

Configuration Item (table: itsm_configuration_items properties: authorizable)

Description | Column | Related to
--- | --- | ---
Administrator Organization, The type and name of the configuration item administrator's organization. (Reference to Organization, Number 18) | cit_admin_org_oid | itsm_organizations
Administrator Person, System administrator responsible for first line maintenance of the configuration item. (Reference to Person, Number 18) | cit_admin_per_oid | itsm_persons
Administrator Workgroup, Workgroup of the current configuration item's administrator. (Reference to Workgroup, Number 18) | cit_admin_wog_oid | itsm_workgroups
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | cit_attachment_exists |
Blocked, Blocked check box. If selected, the configuration item cannot be related to other configuration items. (Boolean, Number 1) | cit_notselectable |
Brand, The configuration item's brand or manufacturer. Select a value from the list. (Reference to Brand, Number 18) | cit_bra_oid | itsm_codes
Category, Configuration item category. The category groups configuration items in a hierarchical structure. In this structure items are grouped based on their function or use. Click Category and select a category from the tree view. (Reference to CI Category, Number 18) | cit_cat_oid | rep_codes
Changes, List of changes applicable to this configuration item. (Set of Change) |  |
Child Configuration Items, List of child items or subitems. Subitems are configuration items that are related to the parent if the child is connected - for example a node in a network - or if the child is an integral part - for example a CD-ROM in a desktop computer. (Set of CI Component) |  | itsm_cicomponents cic_citb_oid
CIOrgs (Set of CI Organization) |  | itsm_ci_orgs cio_cit_oid
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_per_oid | itsm_persons
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | cit_poo_oid | rep_codes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, Configuration item history lines. List of changes applied to the configuration item's information. (Set of History line Configuration) |  | itsm_historylines_config hcf_cit_oid
ID (ID, Number 18) | cit_id |
Incidents, List of incidents. Shows the incidents recorded on the configuration item. (Set of Incident) |  |
IP Address, IP Address (Text 50) | cit_ipaddress |
Location, The location of the configuration item. (Reference to Location, Number 18) | cit_loc_oid | itsm_locations
Maintenance contract, Description of the maintenance contract applicable to the configuration item. (Reference to Maintenance contract, Number 18) | cit_mct_oid | itsm_maintenance_contracts
Managed by service, The operations management service for this CI. Select the operations management service that is applicable for this CI. (Reference to Service, Number 18) | cit_mgmt_service_oid | itsm_services
Max. Installations, Maximum number of installations. Used only for non-unique configuration items. Shows the maximum number occurrences allowed for a non-unique configuration items. (Number 9) | cit_maxinstall |
Name 1, Main name for the configuration item. Used for communicating information on the configuration item or to retrieve the configuration item from the database. (Text 255) | cit_name1 |
Name 2, Extra name for the configuration item. Used for extra identification of the configuration item, for example in users' terms. (Text 255) | cit_name2 |
Object ID (Object ID, Number 18) | cit_oid |
Order number, Order number under which the configuration item is acquired. (Text 50) | cit_ordernr |
Application, Application. To be used for integration with VantagePoint Outage specification. (Text 80) | oui_application |
Msg. Group, Message Group. To be used for integration with VantagePoint Outage specification. (Text 80) | oui_msggroup |
Msg. Operation, Message Operation. To be used for integration with VantagePoint Outage specification. (Reference to Outage Msg Operation, Number 18) | oui_msg_oid | itsm_codes
Msg. Type, Description of the OVO Message Type. Use this to match messages in the integration with the OVO outage specification (Text 80) | oui_msgtype |
Object, Object name specified in an OVO alert. Use this to match messages in the integration with the OVO outage specification (Text 80) | oui_object |
Service Name, Unique identifier of a service in an OVO alert. Pattern-matching may be used. Use this to match messages in the integration with the OVO outage specification (Text 80) | oui_service_name |
Severity, Severity. To be used for integration with VantagePoint Outage specification. (Reference to Outage Severity, Number 18) | oui_sev_oid | itsm_codes
Status variable, Status variable. To be used for integration with VantagePoint Outage specification. (Text 80) | oui_statusvariable |
Text, A string containing all or part of a OVO message text. Use this to match messages in the integration with the OVO outage specification (Text 80) | oui_text |
Outsourced to, Contractor responsible for the configuration item's support. (Reference to Organization, Number 18) | cit_outsource_org_oid | itsm_organizations
Owner Organization, Organization the owner belongs to. (Reference to Organization, Number 18) | cit_owner_org_oid | itsm_organizations
Owner Person, Configuration item owner. The owner holds financial responsibilities for the configuration item. (Reference to Person, Number 18) | cit_owner_per_oid | itsm_persons
Parent CIs, Parent configuration item. The configuration item may be connected to the parent or may be an integral part of the parent. (Set of CI Component) |  | itsm_cicomponents cic_cita_oid
Duration, Time outage of related item(s) will last. (Number 9) | peo_duration |
End, Specifies a date for the last occurrence of the repeating outage. (Date) | peo_recurrenceenddate |
Every, Repeat the outage on a specified day of a specified month. (Date) | peo_yearlyoutagedate |
Friday, Repeats the outage on the specified day. (Boolean, Number 1) | peo_friday |
Monday, Repeats the outage on the specified day. (Boolean, Number 1) | peo_monday |
Outage End, Time outage of the related item will end (Date) | peo_outageend |
Outage Start, Time outage of the related item will start (Date) | peo_outagestart |
Saturday, Repeats the outage on the specified day. (Boolean, Number 1) | peo_saturday |
Start, Specifies the date the outage begins. (Date) | peo_recurrencestartdate |
Sunday, Repeats the outage on the specified day. (Boolean, Number 1) | peo_sunday |
Thursday, Repeats the outage on the specified day. (Boolean, Number 1) | peo_thursday |
Tuesday, Repeats the outage on the specified day. (Boolean, Number 1) | peo_tuesday |
Wednesday, Repeats the outage on the specified day. (Boolean, Number 1) | peo_wednesday |
Weekly, Repeat the outage every week. (Boolean, Number 1) | peo_weekly |
Yearly, Repeat the outage every year. (Boolean, Number 1) | peo_yearly |
Price, Value of the configuration item when acquired from the supplier. (Number 64) | cit_price |
Problems, List of problems. Shows the problems created on the current configuration item. (Set of Problem) |  |
Purchase date, Date the configuration item is acquired. (Date) | cit_purchasedate |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | cit_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | cit_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Related CIs, List of related configuration items. The relation type explains how the two configuration items are related. For example, a desktop PC 'prints to' a printer is a possible relation.. (Set of CI relation) |  | itsm_ci_relations cir_cifrom_oid
Remark, The remark field allows for remarks on the configuration item. Type any information that may help or explain support of the configuration item. (Text 255) | cit_remark |
Search code, Search code of configuration item. The search code is a shorthand for identifying the configuration item. (Text 50) | cit_searchcode |
Serial Number, Serial number of the configuration item. The serial number is a manufacturer's identification of the configuration item. (Text 50) | cit_serialnumber |
Service calls, List of service calls recorded on this configuration item. (Set of Service call) |  |
Service Level, Important configuration items in the IT infrastructure could be related to a service level. The IT department will give support according this service level when an incident is automatically detected. (Reference to Service Level, Number 18) | cit_sel_oid | itsm_service_level
SN Name (Text 255) | cit_sn_name |
SN Socket Address (Reference to Service Navigator Server, Number 18) | cit_sns_oid | itsm_codes
SN Status (Text 40) |  |
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | cit_sourceid |
Status, Status of this configuration item. Shows the position of the configuration item in its lifecycle. The lifecycle of a configuration item starts with being created and ends with being removed. (Reference to CI Status, Number 18) | cit_sta_oid | rep_codes
Supplier, Supplier of the configuration item. (Reference to Organization, Number 18) | cit_org_oid | itsm_organizations
Supported by service, The underpinning service supporting this CI. Select the underpinning service that is applicable for this CI. (Reference to Service, Number 18) | cit_underpin_service_oid | itsm_services
Template (Reference to Template, Number 18) | cit_tem_oid | rep_templates
Time Zone (Reference to Time Zones, Number 18) | cit_tmz_oid | rep_time_zones
Unique, Unique check box. If selected, the configuration item description applies to only one, unique physical item. If cleared, the configuration item description can be applied to a group of physical items. (Boolean, Number 1) | cit_unique |
Used by these Business Services, List of all services that use this configuration item (CI) as a resource. By adding (removing) a service to (from) the list, this CI will (will not) be used by the service. (Set of Configuration Item on Service) |  | itsm_service_cis sci_cit_oid
Users, List of people who use the configuration item. (Set of CI User) |  | itsm_ci_users ciu_cit_oid
Warranty date, Warranty date (Date) | cit_warrantydate |
Work order, List of work orders related to this configuration item. (Set of Configuration Item on Work order) |  | itsm_workorder_cis wci_cit_oid

Configuration Item on Service (table: itsm_service_cis properties: only detail)

Description | Column | Related to
--- | --- | ---
Configuration Item, Configuration item (Reference to Configuration Item, Number 18) | sci_cit_oid | itsm_configuration_items
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | sci_oid |
Service (Reference to Service, Number 18) | sci_srv_oid | itsm_services
Template (Reference to Template, Number 18) | sci_tem_oid | rep_templates

Configuration Item on Work order (table: itsm_workorder_cis properties: only detail)

Description | Column | Related to
--- | --- | ---
Ci Affected By Outage, Indicate if the Ci is affected by the outage as specified in the workorder (Boolean, Number 1) | wci_outageaffected |
Configuration Item, Configuration item to which the workorder is related. (Reference to Configuration Item, Number 18) | wci_cit_oid | itsm_configuration_items
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | wci_oid |
Application, Application. To be used for integration with VantagePoint Outage specification. (Text 80) | wci_oui_application |
Msg. Group, Message Group. To be used for integration with VantagePoint Outage specification. (Text 80) | wci_oui_msggroup |
Msg. Operation, Message Operation. To be used for integration with VantagePoint Outage specification. (Reference to Outage Msg Operation, Number 18) | wci_oui_msg_oid | itsm_codes
Msg. Type, Description of the OVO Message Type. Use this to match messages in the integration with the OVO outage specification (Text 80) | wci_oui_msgtype |
Object, Object name specified in an OVO alert. Use this to match messages in the integration with the OVO outage specification (Text 80) | wci_oui_object |
Service Name, Unique identifier of a service in an OVO alert. Pattern-matching may be used. Use this to match messages in the integration with the OVO outage specification (Text 80) | wci_oui_service_name |
Severity, Severity. To be used for integration with VantagePoint Outage specification. (Reference to Outage Severity, Number 18) | wci_oui_sev_oid | itsm_codes
Status variable, Status variable. To be used for integration with VantagePoint Outage specification. (Text 80) | wci_oui_statusvariable |
Text, A string containing all or part of a OVO message text. Use this to match messages in the integration with the OVO outage specification (Text 80) | wci_oui_text |
Planned CI Values (Set of Planned CI Value) |  | itsm_planned_ci_values pcv_wci_oid
Template (Reference to Template, Number 18) | wci_tem_oid | rep_templates
Work order, Work order to which the configuration item is related. (Reference to Work order, Number 18) | wci_wor_oid | itsm_workorders

Contract status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

E-mail hostname (table: itsm_email_hostnames properties: code)

Description | Column | Related to
--- | --- | ---
Blocked (Boolean, Number 1) | ehn_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Hostname, Only users with specific email accounts are accepted as SP End Users. Define here the valid hostnames. (Format email address: <username>@<hostname>) (Text 255) | ehn_hostnamespaccount |
Object ID (Object ID, Number 18) | ehn_oid |
Template (Reference to Template, Number 18) | ehn_tem_oid | rep_templates

E-mail Priority Mapping (table: itsm_mailpriority_mapping properties: code, cached)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Importance, E-mail importance code you want to map to a service call priority code. Choose High, Medium or Low from the list. (Text 40) | mpm_mailpriority |
Object ID (Object ID, Number 18) | mpm_oid |
Priority, Service call priority code you want to map to an e-mail message importance code. (Reference to Priority, Number 18) | mpm_pri_oid | itsm_codes
Template (Reference to Template, Number 18) | mpm_tem_oid | rep_templates

E-mail Service Call (table: itsm_emailsc properties: authorizable)

Description | Column | Related to
--- | --- | ---
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | esc_attachmentexists |
BCC Address, BCC Address in E-mail (Text 4000) | itsm_emailsc_bcc ebc_bccaddress |
Blocked (Boolean, Number 1) | esc_blocked |
Body, Body in E-mail (Text 65535) | esc_body |
CC Address, CC Address in E-mail (Text 4000) | itsm_emailsc_cc ecc_ccaddress |
Date, Date when the E-mail has been sent or received. It is set automatically by the system (Date) | esc_date |
Folder (Reference to Folder, Number 18) | esc_folder_oid | rep_codes
From Address, From Address in E-mail (Text 4000) | itsm_emailsc_from efr_fromaddress |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
ID, Used to identify the item when communicating information about the item (ID, Number 18) | esc_id |
Importance, Importance of E-mail (Reference to E-mail Priority Mapping, Number 18) |  |
Incoming, Telling whether this E-mail has been received or sent-out, and so the direction of the E-mail (Boolean, Number 1) | esc_incoming |
Object ID (Object ID, Number 18) | esc_oid |
Priority (Number 9) | esc_priority |
Service call (Reference to Service call, Number 18) | esc_ser_oid | itsm_servicecalls
Source, The E-mail Source, that explains where this E-mail originated from. It is set automatically by the system (Reference to E-mail Source, Number 18) | esc_source_oid | rep_codes
Subject, Subject in E-mail (Text 255) | esc_subject |
Template (Reference to Template, Number 18) | esc_tem_oid | rep_templates
To Address, To Address in E-mail (Text 4000) | itsm_emailsc_to eto_toaddress |

FAQ Group (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Children, List of children for this code. (Set of Code hierarchical) |  | itsm_codes cod_cod_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Code hierarchical, Number 18) | cod_cod_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Free Day (table: itsm_free_days properties: code, cached)

Description | Column | Related to
--- | --- | ---
Date, Free days. Days the organization does not work. Click the list button to select the date from the calendar. (Date) | frd_freeday |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | frd_oid |
Template (Reference to Template, Number 18) | frd_tem_oid | rep_templates

Full name (table: itsm_persons properties: only detail)

Description | Column | Related to
--- | --- | ---
First name, First name of the person. (Text 50) | per_firstname |
Last name, Surname or family name of the person. (Text 50) | per_lastname |
Middle name, Second name of the person. Can be used for Edward from the name John Edward Smith or for Petrovitch from the name Michail Petrovitch Rjaoezov. (Text 50) | per_middlename |
Suffix, Full name suffix. Sr. for Senior, III as in John Edward Smith III, job titles or status titles are common suffixes. (Text 50) | per_suffix |
Title, Term of address for the person. Mr., Ms. or Mrs. are common titles. (Text 50) | per_title |

General Checklist (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Questions (Set of Question) |  | itsm_checklist_questions cqu_cod_oid
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

History line Change (table: itsm_historylines_change properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | hch_valueatr_oid | ifc_attributes
Change (Reference to Change, Number 18) | hch_cha_oid | itsm_changes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | hch_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_change hih_information |
New value (Text 65535) | hch_newvalue |
Object ID (Object ID, Number 18) | hch_oid |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Spent time (Number 9) | hch_spenttime |
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | hch_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | hch_system |
Template (Reference to Template, Number 18) | hch_tem_oid | rep_templates
Value from, Value from (Number 18) | hch_valuefrom |
Value to, Value to (Number 18) | hch_valueto |

History line Configuration (table: itsm_historylines_config properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | hcf_valueatr_oid | ifc_attributes
Configuration (Reference to Configuration Item, Number 18) | hcf_cit_oid | itsm_configuration_items
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | hcf_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_conf hic_information |
New value (Text 65535) | hcf_newvalue |
Object ID (Object ID, Number 18) | hcf_oid |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | hcf_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | hcf_system |
Template (Reference to Template, Number 18) | hcf_tem_oid | rep_templates
Value from, Value from (Number 18) | hcf_valuefrom |
Value to, Value to (Number 18) | hcf_valueto |

History line Incident (table: itsm_historylines_incident properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | hin_valueatr_oid | ifc_attributes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | hin_attachmentexists |
Incident (Reference to Incident, Number 18) | hin_inc_oid | itsm_incidents
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_incident hii_information |
New value (Text 65535) | hin_newvalue |
Object ID (Object ID, Number 18) | hin_oid |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Spent time (Number 9) | hin_spenttime |
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | hin_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | hin_system |
Template (Reference to Template, Number 18) | hin_tem_oid | rep_templates
Value from, Value from (Number 18) | hin_valuefrom |
Value to, Value to (Number 18) | hin_valueto |

History line Maintenance Contract (table: itsm_historylines_mct properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | hmc_valueatr_oid | ifc_attributes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | hmc_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_maincon him_information |
Maintenance contract (Reference to Maintenance contract, Number 18) | hmc_mct_oid | itsm_maintenance_contracts
New value (Text 65535) | hmc_newvalue |
Object ID (Object ID, Number 18) | hmc_oid |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | hmc_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | hmc_system |
Template (Reference to Template, Number 18) | hmc_tem_oid | rep_templates
Value from, Value from (Number 18) | hmc_valuefrom |
Value to, Value to (Number 18) | hmc_valueto |

History line Organization (table: itsm_historylines_organization properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | iho_valueatr_oid | ifc_attributes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | iho_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_organization hio_information |
New value (Text 65535) | iho_newvalue |
Object ID (Object ID, Number 18) | iho_oid |
Organization (Reference to Organization, Number 18) | iho_org_oid | itsm_organizations
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | iho_acc_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | iho_mod_acc_oid | rep_accounts
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | iho_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | iho_system |
Template (Reference to Template, Number 18) | iho_tem_oid | rep_templates
Value from, Value from (Number 18) | iho_valuefrom |
Value to, Value to (Number 18) | iho_valueto |

History line Person (table: itsm_historylines_person properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | hps_valueatr_oid | ifc_attributes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | hps_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_person hir_information |
New value (Text 65535) | hps_newvalue |
Object ID (Object ID, Number 18) | hps_oid |
Person (Reference to Person, Number 18) | hps_per_oid | itsm_persons
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | hps_acc_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | hps_mod_acc_oid | rep_accounts
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | hps_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | hps_system |
Template (Reference to Template, Number 18) | hps_tem_oid | rep_templates
Value from, Value from (Number 18) | hps_valuefrom |
Value to, Value to (Number 18) | hps_valueto |

History line Problem (table: itsm_historylines_problem properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | hpr_valueatr_oid | ifc_attributes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | hpr_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_problem hip_information |
New value (Text 65535) | hpr_newvalue |
Object ID (Object ID, Number 18) | hpr_oid |
Problem (Reference to Problem, Number 18) | hpr_pro_oid | itsm_problems
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | hpr_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | hpr_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Spent time (Number 9) | hpr_spenttime |
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | hpr_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | hpr_system |
Template (Reference to Template, Number 18) | hpr_tem_oid | rep_templates
Value from, Value from (Number 18) | hpr_valuefrom |
Value to, Value to (Number 18) | hpr_valueto |

History line Project (table: itsm_historylines_projects properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | hpj_attribute | ifc_attributes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | hpj_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_project hsj_information |
New value (Text 65535) | hpj_newvalue |
Object ID (Object ID, Number 18) | hpj_oid |
Project, History line (Reference to Project, Number 18) | hpj_prj_oid | itsm_projects
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | hpj_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | hpj_cre_acc_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | hpj_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | hpj_mod_acc_oid | rep_accounts
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | hpj_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | hpj_system |
Template (Reference to Template, Number 18) | hpj_tem_oid | rep_templates
Value from, Value from (Number 18) | hpj_value_from |
Value to, Value to (Number 18) | hpj_value_to |

History line Service (table: itsm_historylines_service properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | hsr_attribute | ifc_attributes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | hsr_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_service hsi_information |
New value (Text 65535) | hsr_newvalue |
Object ID (Object ID, Number 18) | hsr_oid |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | hsr_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | hsr_cre_acc_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | hsr_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | hsr_mod_acc_oid | rep_accounts
Service, History line (Reference to Service, Number 18) | hsr_srv_oid | itsm_services
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | hsr_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | hsr_system |
Template (Reference to Template, Number 18) | hsr_tem_oid | rep_templates
Value from, Value from (Number 18) | hsr_value_from |
Value to, Value to (Number 18) | hsr_value_to |

History line Service call (table: itsm_historylines_servicecall properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | hsc_valueatr_oid | ifc_attributes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | hsc_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_servicecall his_information |
New value (Text 65535) | hsc_newvalue |
Object ID (Object ID, Number 18) | hsc_oid |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | hsc_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_createdby_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | hsc_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modifiedby_oid | rep_accounts
Service call (Reference to Service call, Number 18) | hsc_ser_oid | itsm_servicecalls
Spent time (Number 9) | hsc_spenttime |
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | hsc_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | hsc_system |
Template (Reference to Template, Number 18) | hsc_tem_oid | rep_templates
Value from, Value from (Number 18) | hsc_valuefrom |
Value to, Value to (Number 18) | hsc_valueto |

History line Service Level Agreement (table: itsm_historylines_sla properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | hsa_attribute | ifc_attributes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | hsa_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_sla hia_information |
New value (Text 65535) | hsa_newvalue |
Object ID (Object ID, Number 18) | hsa_oid |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | hsa_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | hsa_cre_acc_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | hsa_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | hsa_mod_acc_oid | rep_accounts
Service Level Agreement, History line (Reference to Service Level Agreement, Number 18) | hsa_sla_oid | itsm_service_level_agreements
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | hsa_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | hsa_system |
Template (Reference to Template, Number 18) | hsa_tem_oid | rep_templates
Value from, Value from (Number 18) | hsa_value_from |
Value to, Value to (Number 18) | hsa_value_to |

History line Workgroup (table: itsm_historylines_workgroup properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | ihw_valueatr_oid | ifc_attributes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | ihw_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_workgroup hig_information |
New value (Text 65535) | ihw_newvalue |
Object ID (Object ID, Number 18) | ihw_oid |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | ihw_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | ihw_modified_by_oid | rep_accounts
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | ihw_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | ihw_system |
Template (Reference to Template, Number 18) | ihw_tem_oid | rep_templates
Value from, Value from (Number 18) | ihw_valuefrom |
Value to, Value to (Number 18) | ihw_valueto |
Workgroup (Reference to Workgroup, Number 18) | ihw_wog_oid | itsm_workgroups

History line Work order (table: itsm_historylines_workorder properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | hwk_valueatr_oid | ifc_attributes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | hwk_attachmentexists |
Information, History line information. This text box can contain any extra information you want to pass to colleagues. (Text 4000) | itsm_hist_info_workorder hiw_information |
New value (Text 65535) | hwk_newvalue |
Object ID (Object ID, Number 18) | hwk_oid |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Spent time (Number 9) | hwk_spenttime |
Subject, History line subject. Subject or reason to create this history line. If the current history line is created by Service Desk, you cannot edit this field. (Text 255) | hwk_subject |
System, System check box. If selected, Service Desk created the history line subject. Users cannot edit the subject of system history lines. This check box cannot be changed. (Boolean, Number 1) | hwk_system |
Template (Reference to Template, Number 18) | hwk_tem_oid | rep_templates
Value from, Value from (Number 18) | hwk_valuefrom |
Value to, Value to (Number 18) | hwk_valueto |
Work order (Reference to Work order, Number 18) | hwk_wor_oid | itsm_workorders

Holiday (table: itsm_holidays properties: only detail, cached)

Description | Column | Related to
--- | --- | ---
Date (Date) | hol_date |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
HolidayCalendar (Reference to HolidayCalendar, Number 18) | hol_hcr_oid | itsm_holiday_calendars
Name (Text 50) | hol_name |
Object ID (Object ID, Number 18) | hol_oid |
Template (Reference to Template, Number 18) | hol_tem_oid | rep_templates

HolidayCalendar (table: itsm_holiday_calendars properties: code, cached)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Holidays (Set of Holiday) |  | itsm_holidays hol_hcr_oid
Include free days (Boolean, Number 1) | hcr_includefreedays |
Name (Text 50) | hcr_name |
Object ID (Object ID, Number 18) | hcr_oid |
Standard free days (Set of Free Day) |  |
Template (Reference to Template, Number 18) | hcr_tem_oid | rep_templates

Impact (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Ordering, Ordering number for the current code. The lower the number the higher the code will be shown in lists. Once a code is used, do not modify the number. (Number 9) | cod_ordering |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Impact Priority Setting (table: itsm_priorityimpactsettings properties: only detail, cached)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Impact (Reference to Impact, Number 18) | pis_imp_oid | itsm_codes
Object ID (Object ID, Number 18) | pis_oid |
Priority (Reference to Priority, Number 18) | pis_pri_oid | itsm_codes
Service Level, Service level (Reference to Service Level, Number 18) | pis_sel_oid | itsm_service_level
Template (Reference to Template, Number 18) | pis_tem_oid | rep_templates

Incident (table: itsm_incidents properties: authorizable)

Description | Column | Related to
--- | --- | ---
Actual Cost, The actual costs of handling this item. (Number 64) | inc_actualcost |
Actual Duration, Total time worked on this item. (Number 9) | inc_actualduration |
Actual Finish, The date work on this item finished. (Date) | inc_actualfinish |
Actual Start, The date working on this item was started. (Date) | inc_actualstart |
Analyzed data Incident (Set of Analyzed data Incident) |  | itsm_analyzed_data agd_inc_oid
#Approved approvers (Number 9) | inc_apt_nrofapproversapproved |
#Approvers Required, The number of approvers who need to approve to get approval for this item. (Number 9) | inc_apt_nrofapproversrequired |
Approval group, Workgroup of the approvers (Reference to Workgroup, Number 18) | inc_apt_wog_oid | itsm_workgroups
Approval Status, The status of the approval. Only at status Active it possible to vote for approval (Reference to Approval Status, Number 18) | inc_apt_status | itsm_codes
Approval Votes, People responsible for voting for approval (Set of Approval Vote) |  | itsm_approver_votes apv_apt_oid
Deadline, The deadline which before all approvers have to vote. If the deadline is passed and the approval result is still incomplete the result will be set to Rejected (Date) | inc_apt_deadline |
Description, Approval Description (Text 80) | inc_apt_description |
NrOfApprovers (Number 9) | inc_apt_nrofapprovers |
Result, This field reflects the state of the approval for this item (Text 40) |  |
Strategy, The used strategy for this approval (Text 255) |  |
Assignment Priority, Priority of assignment The priority shows the importance of quick handling of the assignment. The higher the priority, the faster the assignment must be addressed. (Reference to Assignment Priority, Number 18) | inc_assign_priority | itsm_codes
Assignment Status, The status shows the progress of the responsible person's work towards completion. (Reference to Assignment Status, Number 18) | inc_assign_status | itsm_codes
External Deadline, The latest date the external organization is expected to complete and deliver work they are made responsible for . (Date) | inc_assign_extdeadline |
From person, Person who created the current assignment. This person assigned the current item to another person. (Reference to Person, Number 18) | inc_assign_person_from | itsm_persons
From workgroup, The workgroup of the person who created the current assignment. (Reference to Workgroup, Number 18) | inc_assign_workgroup_from | itsm_workgroups
Information from sender, From this field the receiver of the service call can review additional information about the service call that was added by the sender (Text 4000) | itsm_inc_ass_information iai_ass_information |
Information to receiver, In this field the sender who assigns the service call to a receiver can add information about the background of the service call, some additional information, and why it is sent to this receiver (Text 4000) |  |
Reference #, Reference number used to communicate information with the responsible external organization. (Text 50) | inc_assign_referencenumber |
To external Organization, External organization responsible for handling the item. (Reference to Organization, Number 18) | ass_contr_out_org | itsm_organizations
To external Person, Employee of the external organization responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | ass_contr_out_per | itsm_persons
To person, Person made responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | inc_assign_person_to | itsm_persons
To workgroup, Work group of the person currently responsible for this item. (Reference to Workgroup, Number 18) | inc_assign_workgroup | itsm_workgroups
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | inc_attachment_exists |
Category, The incident's category. The category groups incidents in a hierarchical structure. In this structure incidents are grouped based on their likely or apparent cause. Click Category and select a category from the tree view. (Reference to Incident Category, Number 18) | inc_cat_oid | rep_codes
Category (Service Today) (Reference to Category, Number 18) | inc_cat_oid | rep_codes
Classification, Classification of incident. (Reference to Incident Classification, Number 18) | inc_cla_oid | itsm_codes
Closure code, Closure code. Specifies reason for closed status of incident. (Reference to Incident Closure code, Number 18) | inc_clo_oid | itsm_codes
Configuration Item, The configuration item that is subject of the current item. (Reference to Configuration Item, Number 18) | inc_cit_oid | itsm_configuration_items
Deadline, The latest date the results and work related to this item must be completed and delivered. (Date) | inc_deadline |
Deadline Service, Shows the Service from which the Deadline has been calculated. (Reference to Service, Number 18) | inc_deadline_srv_oid | itsm_services
Description, Description of current item. The description 's a summary of the information field. The description is used for later retrieval and analyses. (Text 80) | inc_description |
Early finish, The earliest date planned that work on this item will be finalized. (Date) | inc_earlyfinish |
Early start, The earliest date planned that working on this item will start. (Date) | inc_earlystart |
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_inc_per_oid | itsm_persons
Estimated finish, Date and time that the item is expected to be finished. (Date) |  |
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | inc_poo_oid | rep_codes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, Incident history lines. List of changes applied to the incident's information. (Set of History line Incident) |  | itsm_historylines_incident hin_inc_oid
ID, Identification number. Used to identify the item when communicating information about the item. (ID, Number 18) | inc_id |
Impact, The impact reflects how much the work of the caller is impaired or in what extent the work of other people is impaired. (Reference to Impact, Number 18) | inc_imp_oid | itsm_codes
Information, Full information of this item. Should contain all necessary information needed to handle the item or work on the item. (Text 4000) | itsm_inc_information ini_information |
Initiator, The person who is responsible for initiating approval for this item. (Reference to Person, Number 18) | inc_initiator_per_oid | itsm_persons
Late finish, The latest date planned to finalize work on this item. (Date) | inc_latefinish |
Late start, The latest date planned to start work on this item. (Date) | inc_latestart |
Max. duration, Maximum amount of time allowed for working on the current item. (Number 9) | inc_maximumduration |
Object ID (Object ID, Number 18) | inc_oid |
Open duration, Actual time the current item is opened. (Number 9) |  |
Planned Cost, Planned total cost of handling this item. (Number 64) | inc_plannedcost |
Planned Duration, Planned duration of work on this item. (Number 9) | inc_planduration |
Planned Finish, Date planned to finalize work on this item. (Date) | inc_planfinish |
Planned Start, Planned date to start working on this item. (Date) | inc_planstart |
Priority, The priority reflects the urgency for quick resolution of the item. (Reference to Priority, Number 18) | inc_pri_oid | itsm_codes
Registered, Date and time the current item was created. (Date) |  |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_createdby | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modifiedby | rep_accounts
Relations, List of items related to this incident. (Set of Service Event Relation) |  | itsm_service_relations sre_inc_oid
Remain duration, Remaining duration of work on this item, calculated from the current date to the planned finish date. (Number 9) | itsm_changes cha_remainduration |
Requestor, The person who requested this item. This person is excluded from voting for approval for this item. (Reference to Person, Number 18) | inc_requestor_per_oid | itsm_persons
Service, The service is supplied to customers through a service level agreement. (Reference to Service, Number 18) | inc_srv_oid | itsm_services
Service Level, A service level contains relations with one or more multiple impact-priority dependencies and a schedule. (Reference to Service Level, Number 18) | inc_sel_oid | itsm_service_level
Severity (Reference to Severity, Number 18) | inc_sev_oid | itsm_codes
SLA, The service level agreement combines the service with a service level in order to supply the service to a receiver. (Reference to Service Level Agreement, Number 18) | inc_sla_oid | itsm_service_level_agreements
SLA Report Negative Indications (Set of SLA Report Negative Indications) |  | itsm_sla_report_neg_indication rni_inc_oid
Solution, Proposed or accepted and working solution to the incident. (Text 255) | inc_solution |
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | inc_sourceid |
Status, Status of this incident. Shows the position of the incident in its lifecycle. The lifecycle of an incident starts with being created and ends with being removed. (Reference to Incident Status, Number 18) | inc_sta_oid | rep_codes
Status (Service Today) (Reference to Status, Number 18) | inc_sta_oid | rep_codes
Subcontract calls (Set of Service call) |  | itsm_servicecalls scc_from_inc_oid
Template (Reference to Template, Number 18) | inc_tem_oid | rep_templates
To deadline, Amount of time till deadline is reached (Number 9) |  |
Wait for Work Order Completion (Boolean, Number 1) | inc_waitforwo |
Workaround, Suggested workaround to be used until a definite solution is found. (Text 255) | inc_workaround |
Work orders, List of workorders related to this incident. Work orders describe work resulting from the incident. (Set of Work order) |  | itsm_workorders wor_inc_oid

Incident Category (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Attributes (Set of Attributes per category) |  | rep_attr_per_category apc_cat_oid
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Children, List of children for this code. (Set of Kernel Code Hierarchical) |  | rep_codes rcd_rcd_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Incidents, List of all incidents that are assigned the current category. (Set of Incident) |  | itsm_incidents inc_cat_oid
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Kernel Code Hierarchical, Number 18) | rcd_rcd_oid | rep_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Incident Classification (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Children, List of children for this code. (Set of Code hierarchical) |  | itsm_codes cod_cod_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Code hierarchical, Number 18) | cod_cod_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Incident Closure code (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Children, List of children for this code. (Set of Code hierarchical) |  | itsm_codes cod_cod_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Code hierarchical, Number 18) | cod_cod_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Incident Priority Duration setting (table: itsm_prioritydurationsettings properties: code, cached)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Max. duration (Number 9) | pds_maximumduration |
Object ID (Object ID, Number 18) | pds_oid |
Priority, Priority code. Select a priority code from the list, then enter the time allowed for a service call registered with this priority in hours and minutes. (Reference to Priority, Number 18) | pds_priority | itsm_codes
Template (Reference to Template, Number 18) | pds_tem_oid | rep_templates

Incident Status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
State (Reference to State, Number 18) | itsm_workflow_statuses wos_sta_oid | itsm_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Location (table: itsm_locations properties: code)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, this location cannot be used. (Boolean, Number 1) | loc_notselectable |
Category, Location category. (Reference to Location Category, Number 18) | loc_cat_oid | rep_codes
Child Locations, Child locations defined for the current location. (Set of Location) |  | itsm_locations loc_parent
Configuration items, List of configuration items that can be found in this location. (Set of Configuration Item) |  | itsm_configuration_items cit_loc_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | loc_oid |
Parent Location, Parent location of the current location. (Reference to Location, Number 18) | loc_parent | itsm_locations
Remark, Remark about the location. (Text 255) | loc_remark |
Search code, Location search code. Used as short hand to retrieve the location information. (Text 50) | loc_searchcode |
Template (Reference to Template, Number 18) | loc_tem_oid | rep_templates

Location Category (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Attributes (Set of Attributes per category) |  | rep_attr_per_category apc_cat_oid
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Children, List of children for this code. (Set of Kernel Code Hierarchical) |  | rep_codes rcd_rcd_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Kernel Code Hierarchical, Number 18) | rcd_rcd_oid | rep_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Maintenance contract (table: itsm_maintenance_contracts properties: authorizable)

Description | Column | Related to
--- | --- | ---
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | mct_attachment_exists |
Blocked, Blocked check box. If selected, the current maintenance contract cannot be selected for configuration items. (Boolean, Number 1) | mct_notselectable |
Configuration items, List of configuration items to which the current maintenance contract does apply. (Set of Configuration Item) |  | itsm_configuration_items cit_mct_oid
Description, Description of the maintenance contract. (Text 80) | mct_description |
End date, Date the current maintenance contract will expire. (Date) | mct_enddate |
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_mct_per_oid | itsm_persons
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | mct_poo_oid | rep_codes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, List of history lines. With the history lines you can track the modifications to this item. What modifications are tracked is set by the system administrator. (Set of History line Maintenance Contract) |  | itsm_historylines_mct hmc_mct_oid
Name, Name of the maintenance contract. Use the name as reference to the current contract. (Text 50) | mct_name |
Object ID (Object ID, Number 18) | mct_oid |
Organization, Contracting company, or responsible organization for the current maintenance contract. (Reference to Organization, Number 18) | mct_org_oid | itsm_organizations
Price, Price or direct cost of the maintenance contract. (Number 64) | mct_price |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | mct_sourceid |
Start date, Date the current maintenance contract was first active or will be active. (Date) | mct_startdate |
Status, Status of the maintenance contract. Select a status from the list. (Reference to Contract status, Number 18) | mct_sta_oid | rep_codes
Template (Reference to Template, Number 18) | mct_tem_oid | rep_templates

Medium (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Member (table: itsm_members properties: only detail)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | mem_oid |
Person, Name of a specialist. The specialist is a member of the workgroup. (Reference to Person, Number 18) | mem_per_oid | itsm_persons
Template (Reference to Template, Number 18) | mem_tem_oid | rep_templates
Workgroup, Workgroup for the specialist. The specialist is a member of this workgroup. (Reference to Workgroup, Number 18) | mem_wog_oid | itsm_workgroups

Metric Code (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Metric Type (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

OccasionalOutage (table: itsm_workorders properties: only detail)

Description | Column | Related to
--- | --- | ---
Duration, Time outage of related item(s) will last. (Number 9) |  |
End Available Period (Date) | wor_occ_availableperiodend |
End Suggested Period (Date) | wor_occ_suggestedperiodend |
Outage End, Time outage of related items(s) will end (Date) | wor_occ_outageend |
Outage Start, Time outage of related items(s) will start (Date) | wor_occ_outagestart |
Planning PeriodEnd (Date) | wor_occ_planningperiodend |
Planning PeriodStart, The period in which outage should occur (Date) | wor_occ_planningperiodstart |
Start Available Period, The period with equal impact on services in which outage can occur (Date) | wor_occ_availableperiodstart |
SuggestedPeriod, The period with the least impact on related services (Date) | wor_occ_suggestedperiodstart |

Openings Schedule (table: itsm_openings_schedules properties: code)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Name (Text 50) | osc_name |
Object ID (Object ID, Number 18) | osc_oid |
Support Hours (Set of Support Hours) |  | itsm_support_hours sho_osc_oid
Template (Reference to Template, Number 18) | osc_tem_oid | rep_templates

Organization (table: itsm_organizations properties: authorizable)

Description | Column | Related to
--- | --- | ---
Addresses, Addresses used to locate an organization or to send e-mail to the organization. The address type shows the intended use of the address. (Set of Address) |  | itsm_addresses adr_org_oid
Administrator of Configuration Item (Set of Configuration Item) |  | itsm_configuration_items cit_admin_org_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | org_attachment_exists |
Blocked (Boolean, Number 1) | org_notselectable |
Category, Organization category. (Reference to Organization Category, Number 18) | org_cat_oid | rep_codes
Child Organizations, Child organizations defined for the current organization. (Set of Organization) |  | itsm_organizations org_parent
Configuration items (Set of CI Organization) |  | itsm_ci_orgs cio_org_oid
E-mail, Organization e-mail address. Used as the main e-mail address to send e-mail to the organization. Persons may have individual e-mail addresses. (Text 80) | org_email |
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_org_per_oid | itsm_persons
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | org_poo_oid | rep_codes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, Organization history line. List of changes applied to the organization's information. (Set of History line Organization) |  | itsm_historylines_organization iho_org_oid
Location, Physical location of organization. (Reference to Location, Number 18) | org_loc_oid | itsm_locations
Maintenance Contracts (Set of Maintenance contract) |  | itsm_maintenance_contracts mct_org_oid
Manager, Person in charge of this organization. (Reference to Person, Number 18) | org_manager_oid | itsm_persons
Name 1, Name of organization. Main name used for organization. (Text 50) | org_name1 |
Name 2, Name of organization. Extra name information. (Text 50) | org_name2 |
Object ID (Object ID, Number 18) | org_oid |
Owner of Configuration Item (Set of Configuration Item) |  | itsm_configuration_items cit_owner_org_oid
Parent, Parent organization defined for the current organization. (Reference to Organization, Number 18) | org_parent | itsm_organizations
Persons, List of persons employed or otherwise connected to this organization. (Set of Person) |  | itsm_persons per_org_oid
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Remark, Remark about the organization. (Text 255) | org_remark |
Search code, Organization search code. Used as short hand to retrieve the organization information. (Text 50) | org_searchcode |
Service calls, List of servicecalls created for employees of the current organization. (Set of Service call) |  | itsm_servicecalls ser_caller_org
Service Level Agreements (Set of Service Level Agreement) |  | itsm_service_level_agreements sla_pro_org_oid
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | org_sourceid |
Status, Status of this organization. Shows the organization's position in its life cycle, from being created to being removed. (Reference to Organization Status, Number 18) | org_sta_oid | rep_codes
Telephone, List of telephone numbers used by this organization. Telephone type shows the intended use of the telephone number. (Set of Telephone) |  | itsm_telephones tel_org_oid
Telephone number, This telephone number can be selected in a view based on organization (Text 40) | org_primarytelnr |
Template (Reference to Template, Number 18) | org_tem_oid | rep_templates
Time Zone (Reference to Time Zones, Number 18) | org_tmz_oid | rep_time_zones
Web page, Organization Web page. (Text 255) | org_webpage |

Organization Category (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Attributes (Set of Attributes per category) |  | rep_attr_per_category apc_cat_oid
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Children, List of children for this code. (Set of Kernel Code Hierarchical) |  | rep_codes rcd_rcd_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Kernel Code Hierarchical, Number 18) | rcd_rcd_oid | rep_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Organization Status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Outage Info properties: only detail)

Description | Column | Related to
--- | --- | ---
Application, Application. To be used for integration with VantagePoint Outage specification. (Text 80) |  |
Msg. Group, Message Group. To be used for integration with VantagePoint Outage specification. (Text 80) |  |
Msg. Operation, Message Operation. To be used for integration with VantagePoint Outage specification. (Reference to Outage Msg Operation, Number 18) |  |
Msg. Type, Description of the OVO Message Type. Use this to match messages in the integration with the OVO outage specification (Text 80) |  |
Object, Object name specified in an OVO alert. Use this to match messages in the integration with the OVO outage specification (Text 80) |  |
Service Name, Unique identifier of a service in an OVO alert. Pattern-matching may be used. Use this to match messages in the integration with the OVO outage specification (Text 80) |  |
Severity, Severity. To be used for integration with VantagePoint Outage specification. (Reference to Outage Severity, Number 18) |  |
Status variable, Status variable. To be used for integration with VantagePoint Outage specification. (Text 80) |  |
Text, A string containing all or part of a OVO message text. Use this to match messages in the integration with the OVO outage specification (Text 80) |  |

Outage Msg Operation (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Outage Severity (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

OVIS Metric (table: itsm_internetservicesmetrics properties: only detail)

Description | Column | Related to
--- | --- | ---
Availability Condition, Operator used to set up a condition. If a condition is not met, then a SLO violation is counted. (Text 50) | ism_availabilitycondition |
Availability Threshold, Value used to set up a condition. If a condition is not met, then a SLO violation is counted. (Number 9) | ism_availabilitythreshold |
Description, The name of this metric. Is used in the list of metrics in the SLA (Text 255) | ism_description |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Locations, Location of the probe used to measure. (Set of OVIS Metric Location) |  | itsm_ismlocations isl_ism_oid
Object ID (Object ID, Number 18) | ism_oid |
Probe type, Name of probe used to measure the metric. See Internet Services documentation for more details. (Reference to OVIS Metric Probe Type, Number 18) | ism_rcd_oid | rep_codes
Service Level Agreement (Reference to Service Level Agreement, Number 18) | ism_sla_oid | itsm_service_level_agreements
Targets, Subjects of Internet Services measurements. Usually the URL used to measure the reponse of a protocol. (Set of OVIS Metric Target) |  | itsm_ismtargets ist_ism_oid
Template (Reference to Template, Number 18) | ism_tem_oid | rep_templates
Total Response Time Condition, Operator used to set up a condition. If a condition is not met, then a SLO violation is counted. (Text 50) | ism_totalresponsetimecondition |
Total Response Time Threshold, Value used to set up a condition. If a condition is not met, then a SLO violation is counted. (Number 9) | ism_totalresponsetimethreshold |

OVIS Metric Location (table: itsm_ismlocations properties: only detail)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Interval, Number of seconds between two measurments. (Number 9) | isl_interval |
Name, Name of the probe measuring the reponses. The name must be a fully qualified name of an executable. Value is not validated. (Text 255) | isl_name |
Object ID (Object ID, Number 18) | isl_oid |
OVIS Metric (Reference to OVIS Metric, Number 18) | isl_ism_oid | itsm_internetservicesmetrics
Template (Reference to Template, Number 18) | isl_tem_oid | rep_templates
Timeout, Number of seconds that the probe waits for response. If the target does not respond within the timeout time, then the target is considered unavailable without response. (Number 9) | isl_timeout |

OVIS Metric Operator (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

OVIS Metric Probe Type (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

OVIS Metric Target (table: itsm_ismtargets properties: only detail)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Host, Name of the host where the probed service is supplied. (Text 255) | ist_host |
Object ID (Object ID, Number 18) | ist_oid |
OVIS Metric (Reference to OVIS Metric, Number 18) | ist_ism_oid | itsm_internetservicesmetrics
Port, Port number used to probe the give service. (Number 9) | ist_port |
Template (Reference to Template, Number 18) | ist_tem_oid | rep_templates
URL, Location of the resource that is used to measure reponse. The URL is expected to be located on the host. (Text 255) | ist_url |

Periodic Outage (table: itsm_workorders properties: only detail)

Description | Column | Related to
--- | --- | ---
Duration, Time outage of related item(s) will last. (Number 9) |  |
End, Specifies a date for the last occurrence of the repeating outage. (Date) | itsm_configuration_items peo_recurrenceenddate |
Every, Repeat the outage on a specified day of a specified month. (Date) | itsm_configuration_items peo_yearlyoutagedate |
Friday, Repeats the outage on the specified day. (Boolean, Number 1) | itsm_configuration_items peo_friday |
Monday, Repeats the outage on the specified day. (Boolean, Number 1) | itsm_configuration_items peo_monday |
Outage End, Time outage of the related item will end (Date) | itsm_configuration_items peo_outageend |
Outage Start, Time outage of the related item will start (Date) | itsm_configuration_items peo_outagestart |
Saturday, Repeats the outage on the specified day. (Boolean, Number 1) | itsm_configuration_items peo_saturday |
Start, Specifies the date the outage begins. (Date) | itsm_configuration_items peo_recurrencestartdate |
Sunday, Repeats the outage on the specified day. (Boolean, Number 1) | itsm_configuration_items peo_sunday |
Thursday, Repeats the outage on the specified day. (Boolean, Number 1) | itsm_configuration_items peo_thursday |
Tuesday, Repeats the outage on the specified day. (Boolean, Number 1) | itsm_configuration_items peo_tuesday |
Wednesday, Repeats the outage on the specified day. (Boolean, Number 1) | itsm_configuration_items peo_wednesday |
Weekly, Repeat the outage every week. (Boolean, Number 1) | itsm_configuration_items peo_weekly |
Yearly, Repeat the outage every year. (Boolean, Number 1) | itsm_configuration_items peo_yearly |

Person (table: itsm_persons properties: authorizable)

Description | Column | Related to
--- | --- | ---
Account, Account name used by this person to logon to Service Desk. If no account is specified, this person will not be able to logon (Reference to Account, Number 18) | per_acc_oid | rep_accounts
Addresses, Addresses used to locate a person or to send e-mail to a person. The use of the address is reflected in the address type. (Set of Address) |  | itsm_addresses adr_per_oid
Administrator of Configuration Item (Set of Configuration Item) |  | itsm_configuration_items cit_admin_per_oid
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | per_attachment_exists |
Blocked (Boolean, Number 1) | per_notselectable |
Category, The person's category. The category groups persons in a hierarchical structure. In this structure persons are grouped based on the type of function they perform. Click Category and select a category from the tree view. (Reference to Person Category, Number 18) | per_cat_oid | rep_codes
Date of Birth, Birthday of the current person. (Date) | per_birthdate |
E-mail, E-mail address used to send e-mail to this person. The person's organization may have a general e-mail address. (Text 80) | per_email |
E-mail Lowercase (Text 80) | per_emaillower |
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_per_per_oid | itsm_persons
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | per_poo_oid | rep_codes
First name, First name of the person. (Text 50) | per_firstname |
Last name, Surname or family name of the person. (Text 50) | per_lastname |
Middle name, Second name of the person. Can be used for Edward from the name John Edward Smith or for Petrovitch from the name Michail Petrovitch Rjaoezov. (Text 50) | per_middlename |
Suffix, Full name suffix. Sr. for Senior, III as in John Edward Smith III, job titles or status titles are common suffixes. (Text 50) | per_suffix |
Title, Term of address for the person. Mr., Ms. or Mrs. are common titles. (Text 50) | per_title |
Gender, The current person's sex. (Reference) | per_gender |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, Person history lines. List of changes applied to the person's information. (Set of History line Person) |  | itsm_historylines_person hps_per_oid
Identification number (Text 50) | per_identificationnumber |
Initials, The current person's initials. (Text 50) | per_initials |
Job title, The current person's job title. (Text 50) | per_jobtitle |
Location, The current person's location. Use the lookup item button to find and select a location. (Reference to Location, Number 18) | per_loc_oid | itsm_locations
Manager of Change (Set of Change) |  | itsm_changes cha_per_man_oid
Manager of Organization (Set of Organization) |  | itsm_organizations org_manager_oid
Manager of Project (Set of Project) |  | itsm_projects prj_proj_man_oid
Members, List of workgroups. The current person is member of the listed workgroups. (Set of Member) |  | itsm_members mem_per_oid
Name, Name of the current person. This name is usually shown in views. (Text 80) | per_name |
Object ID (Object ID, Number 18) | per_oid |
Organization, The current person's organization. The person is an employee of this organization. Use the lookup item button to find and select an organization. (Reference to Organization, Number 18) | per_org_oid | itsm_organizations
Owner of Configuration Item (Set of Configuration Item) |  | itsm_configuration_items cit_owner_per_oid
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Remark, Any remark about the person's record. (Text 255) | per_remark |
Search code, Person search code. Used as short hand to retrieve the person information. (Text 50) | per_searchcode |
Send me e-mail if I need to approve an item (Boolean, Number 1) | per_sendmemailifineedtoapprove |
Send me e-mail when items are assigned to me. (Boolean, Number 1) | per_allowemail |
Send me e-mail when items are assigned to my group (Boolean, Number 1) | per_allowemail4group |
Service calls, List of service calls. The service calls shown in this list have the current person registered as caller. (Set of Service call) |  | itsm_servicecalls ser_caller_per
Show flashing tray icon when items are assigned to me. (Boolean, Number 1) | per_allowinassignment |
Show flashing tray icon when items are assigned to my group (Boolean, Number 1) | per_allowinassignment4group |
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | per_sourceid |
Status, Status of this person. Shows the position of the person item in its lifecycle. The lifecycle of a person item starts with being created and ends with being removed. (Reference to Person Status, Number 18) | per_sta_oid | rep_codes
Telephone, List of telephone numbers used by this person. Telephone type shows the intended use of the telephone number. (Set of Telephone) |  | itsm_telephones tel_per_oid
Telephone number, This telephone number can be selected in a view based on person (Text 40) | per_primarytelnr |
Template (Reference to Template, Number 18) | per_tem_oid | rep_templates
Time Zone (Reference to Time Zones, Number 18) | per_tmz_oid | rep_time_zones
User of CI (Set of CI User) |  | itsm_ci_users ciu_user_per_oid

Person Category (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Attributes (Set of Attributes per category) |  | rep_attr_per_category apc_cat_oid
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Children, List of children for this code. (Set of Kernel Code Hierarchical) |  | rep_codes rcd_rcd_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Kernel Code Hierarchical, Number 18) | rcd_rcd_oid | rep_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Person Status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Planned CI Value (table: itsm_planned_ci_values properties: only detail)

Description | Column | Related to
--- | --- | ---
Attribute (Reference to Attribute, Number 18) | pcv_atr_oid | ifc_attributes
Attribute (Text 80) |  |
Attribute in aggregation (Reference to Attribute, Number 18) | pcv_atr_aggregation_oid | ifc_attributes
Configuration Item on Work order (Reference to Configuration Item on Work order, Number 18) | pcv_wci_oid | itsm_workorder_cis
Current value (Text 65535) |  |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Make empty (Boolean, Number 1) | pcv_makeempty |
Object ID (Object ID, Number 18) | pcv_oid |
Planned value (Text 4000) |  |
Required (Boolean, Number 1) |  |
Template (Reference to Template, Number 18) | pcv_tem_oid | rep_templates
Use Relative Date (Boolean, Number 1) | pcv_userelativedate |
Value (Text 4000) | pcv_value |

Priority (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Ordering, Ordering number for the current code. The lower the number the higher the code will be shown in lists. Once a code is used, do not modify the number. (Number 9) | cod_ordering |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Problem (table: itsm_problems properties: authorizable)

Description | Column | Related to
--- | --- | ---
Actual Cost, The actual costs of handling this item. (Number 64) | pro_actualcost |
Actual Duration, Total time worked on this item. (Number 9) | pro_actualduration |
Actual Finish, The date work on this item finished. (Date) | pro_actualfinish |
Actual Start, The date working on this item was started. (Date) | pro_actualstart |
Analyzed data Problem (Set of Analyzed data Problem) |  | itsm_analyzed_data agd_pro_oid
#Approved approvers (Number 9) | pro_apt_nrofapproversapproved |
#Approvers Required, The number of approvers who need to approve to get approval for this item. (Number 9) | pro_apt_nrofapproversrequired |
Approval group, Workgroup of the approvers (Reference to Workgroup, Number 18) | pro_apt_wog_oid | itsm_workgroups
Approval Status, The status of the approval. Only at status Active it possible to vote for approval (Reference to Approval Status, Number 18) | pro_apt_status | itsm_codes
Approval Votes, People responsible for voting for approval (Set of Approval Vote) |  | itsm_approver_votes apv_apt_oid
Deadline, The deadline which before all approvers have to vote. If the deadline is passed and the approval result is still incomplete the result will be set to Rejected (Date) | pro_apt_deadline |
Description, Approval Description (Text 80) | pro_apt_description |
NrOfApprovers (Number 9) | pro_apt_nrofapprovers |
Result, This field reflects the state of the approval for this item (Text 40) |  |
Strategy, The used strategy for this approval (Text 255) |  |
Assignment Priority, Priority of assignment The priority shows the importance of quick handling of the assignment. The higher the priority, the faster the assignment must be addressed. (Reference to Assignment Priority, Number 18) | pro_assign_priority | itsm_codes
Assignment Status, The status shows the progress of the responsible person's work towards completion. (Reference to Assignment Status, Number 18) | pro_assign_status | itsm_codes
External Deadline, The latest date the external organization is expected to complete and deliver work they are made responsible for . (Date) | pro_assign_extdeadline |
From person, Person who created the current assignment. This person assigned the current item to another person. (Reference to Person, Number 18) | ass_per_from_oid | itsm_persons
From workgroup, The workgroup of the person who created the current assignment. (Reference to Workgroup, Number 18) | ass_wog_from_oid | itsm_workgroups
Information from sender, From this field the receiver of the service call can review additional information about the service call that was added by the sender (Text 4000) | itsm_pro_ass_information pas_ass_information |
Information to receiver, In this field the sender who assigns the service call to a receiver can add information about the background of the service call, some additional information, and why it is sent to this receiver (Text 4000) |  |
Reference #, Reference number used to communicate information with the responsible external organization. (Text 50) | pro_assign_referencenumber |
To external Organization, External organization responsible for handling the item. (Reference to Organization, Number 18) | ass_contr_out_org | itsm_organizations
To external Person, Employee of the external organization responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | ass_contr_out_per | itsm_persons
To person, Person made responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | ass_per_to_oid | itsm_persons
To workgroup, Work group of the person currently responsible for this item. (Reference to Workgroup, Number 18) | ass_wog_oid | itsm_workgroups
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | pro_attachment_exists |
Category, The problem's category. The category groups problems in a hierarchical structure. In this structure problems are grouped based on type of problem. Click Category and select a category from the tree view. (Reference to Problem Category, Number 18) | pro_cat_oid | rep_codes
Category (Service Today) (Reference to Category, Number 18) | pro_cat_oid | rep_codes
Classification, Classification reflects an assessment of the problem after closing the problem. Click Classification and select a classification code from the tree view. (Reference to Problem Classification, Number 18) | pro_cla_oid | itsm_codes
Closure code, The closure code shows the reason why the status of the problem is closed or not worked on anymore. (Reference to Problem Closure code, Number 18) | pro_clo_oid | itsm_codes
Configuration Item, The configuration item that is subject of the current item. (Reference to Configuration Item, Number 18) | pro_cit_oid | itsm_configuration_items
Deadline, The latest date the results and work related to this item must be completed and delivered. (Date) | pro_deadline |
Description, Description of current item. The description 's a summary of the information field. The description is used for later retrieval and analyses. (Text 80) | pro_description |
Early finish, The earliest date planned that work on this item will be finalized. (Date) | pro_earlyfinish |
Early start, The earliest date planned that working on this item will start. (Date) | pro_earlystart |
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_pro_per_oid | itsm_persons
Estimated finish, Date and time that the item is expected to be finished. (Date) |  |
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | pro_poo_oid | rep_codes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, Problem history lines. List of changes applied to the problem's information. (Set of History line Problem) |  | itsm_historylines_problem hpr_pro_oid
ID, Identification number. Used to identify the item when communicating information about the item. (ID, Number 18) | pro_id |
Impact, The impact reflects how much the work of the caller is impaired or in what extent the work of other people is impaired. (Reference to Impact, Number 18) | pro_imp_oid | itsm_codes
Information, Full information of this item. Should contain all necessary information needed to handle the item or work on the item. (Text 4000) | itsm_pro_information pri_information |
Initiator, The person who is responsible for initiating approval for this item. (Reference to Person, Number 18) | pro_initiator_per_oid | itsm_persons
Known Error, Known Error check box. If selected, the current problem is identified as a known error. E known error is a problem with a known cause, but without solution. (Boolean, Number 1) | pro_prknownerror |
Late finish, The latest date planned to finalize work on this item. (Date) | pro_latefinish |
Late start, The latest date planned to start work on this item. (Date) | pro_latestart |
Max. duration, Maximum amount of time allowed for working on the current item. (Number 9) | pro_maximumduration |
Object ID (Object ID, Number 18) | pro_oid |
Open duration, Actual time the current item is opened. (Number 9) |  |
Planned Cost, Planned total cost of handling this item. (Number 64) | pro_plannedcost |
Planned Duration, Planned duration of work on this item. (Number 9) | pro_planduration |
Planned Finish, Date planned to finalize work on this item. (Date) | pro_planfinish |
Planned Start, Planned date to start working on this item. (Date) | pro_planstart |
Priority, The priority reflects the urgency for quick resolution of the item. (Reference to Priority, Number 18) | pro_pri_oid | itsm_codes
Registered, Date and time the current item was created. (Date) |  |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Relations, List of items related to this problem. (Set of Service Event Relation) |  | itsm_service_relations sre_pro_oid
Remain duration, Remaining duration of work on this item, calculated from the current date to the planned finish date. (Number 9) | itsm_changes cha_remainduration |
Requestor, The person who requested this item. This person is excluded from voting for approval for this item. (Reference to Person, Number 18) | pro_requestor_per_oid | itsm_persons
Solution, Proposed or accepted and working solution given or answer returned to the initiator or owner of the problem. (Text 4000) | itsm_pro_solution prs_solution |
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | pro_sourceid |
Status, Status of this problem Shows the position of the problem in its lifecycle. The lifecycle of a problem starts with being created and ends with being removed. (Reference to Problem Status, Number 18) | pro_sta_oid | rep_codes
Status (Service Today) (Reference to Status, Number 18) | pro_sta_oid | rep_codes
Template (Reference to Template, Number 18) | pro_tem_oid | rep_templates
To deadline, Amount of time till deadline is reached (Number 9) |  |
Wait for Work Order Completion (Boolean, Number 1) | pro_waitforwo |
Workaround, Suggested workaround to be used until a definite solution is found. (Text 255) | pro_workaround |
Work orders, List of workorders related to this problem. Work orders describe work resulting from the problem. (Set of Work order) |  | itsm_workorders wor_pro_oid

Problem Category (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Attributes (Set of Attributes per category) |  | rep_attr_per_category apc_cat_oid
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Children, List of children for this code. (Set of Kernel Code Hierarchical) |  | rep_codes rcd_rcd_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Kernel Code Hierarchical, Number 18) | rcd_rcd_oid | rep_codes
Problems, List of all problems that are registered with the current category. (Set of Problem) |  | itsm_problems pro_cat_oid
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Problem Classification (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Children, List of children for this code. (Set of Code hierarchical) |  | itsm_codes cod_cod_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Code hierarchical, Number 18) | cod_cod_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Problem Closure code (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Children, List of children for this code. (Set of Code hierarchical) |  | itsm_codes cod_cod_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Code hierarchical, Number 18) | cod_cod_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Problem Status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
State (Reference to State, Number 18) | itsm_workflow_statuses wos_sta_oid | itsm_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Project (table: itsm_projects properties: authorizable)

Description | Column | Related to
--- | --- | ---
Actual Cost, The actual costs of handling this item. (Number 64) | prj_actual_cost |
Actual Duration, Total time worked on this item. (Number 9) | prj_actual_duration |
Actual Finish, The date work on this item finished. (Date) | prj_actual_finish |
Actual Start, The date working on this item was started. (Date) | prj_actual_start |
Analyzed data Project (Set of Analyzed data Project) |  | itsm_analyzed_data agd_prj_oid
#Approved approvers (Number 9) | prj_apt_nrofapproversapproved |
#Approvers Required, The number of approvers who need to approve to get approval for this item. (Number 9) | prj_apt_nrofapproversrequired |
Approval group, Workgroup of the approvers (Reference to Workgroup, Number 18) | prj_apt_wog_oid | itsm_workgroups
Approval Status, The status of the approval. Only at status Active it possible to vote for approval (Reference to Approval Status, Number 18) | prj_apt_status | itsm_codes
Approval Votes, People responsible for voting for approval (Set of Approval Vote) |  | itsm_approver_votes apv_apt_oid
Deadline, The deadline which before all approvers have to vote. If the deadline is passed and the approval result is still incomplete the result will be set to Rejected (Date) | prj_apt_deadline |
Description, Approval Description (Text 80) | prj_apt_description |
NrOfApprovers (Number 9) | prj_apt_nrofapprovers |
Result, This field reflects the state of the approval for this item (Text 40) |  |
Strategy, The used strategy for this approval (Text 255) |  |
Assignment Priority, Priority of assignment The priority shows the importance of quick handling of the assignment. The higher the priority, the faster the assignment must be addressed. (Reference to Assignment Priority, Number 18) | prj_assign_priority | itsm_codes
Assignment Status, The status shows the progress of the responsible person's work towards completion. (Reference to Assignment Status, Number 18) | prj_assign_status | itsm_codes
External Deadline, The latest date the external organization is expected to complete and deliver work they are made responsible for . (Date) | prj_assign_extdeadline |
From person, Person who created the current assignment. This person assigned the current item to another person. (Reference to Person, Number 18) | prj_ass_per_from_oid | itsm_persons
From workgroup, The workgroup of the person who created the current assignment. (Reference to Workgroup, Number 18) | prj_ass_wog_from_oid | itsm_workgroups
Information from sender, From this field the receiver of the service call can review additional information about the service call that was added by the sender (Text 4000) | itsm_prj_ass_information pra_ass_information |
Information to receiver, In this field the sender who assigns the service call to a receiver can add information about the background of the service call, some additional information, and why it is sent to this receiver (Text 4000) |  |
Reference #, Reference number used to communicate information with the responsible external organization. (Text 50) | prj_assign_reference |
To external Organization, External organization responsible for handling the item. (Reference to Organization, Number 18) | prj_ass_contr_out_org | itsm_organizations
To external Person, Employee of the external organization responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | prj_ass_contr_out_per | itsm_persons
To person, Person made responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | prj_ass_per_to_oid | itsm_persons
To workgroup, Work group of the person currently responsible for this item. (Reference to Workgroup, Number 18) | prj_ass_wog_oid | itsm_workgroups
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | prj_attachment_exists |
Category (Reference to Project Category, Number 18) | prj_cat_oid | rep_codes
Category (Service Today) (Reference to Category, Number 18) | prj_cat_oid | rep_codes
Change (Set of Change) |  | itsm_changes cha_prj_oid
Deadline, The latest date the results and work related to this item must be completed and delivered. (Date) | prj_deadline |
Description, Description of current item. The description 's a summary of the information field. The description is used for later retrieval and analyses. (Text 80) | prj_description |
Early finish, The earliest date planned that work on this item will be finalized. (Date) | prj_early_finish |
Early start, The earliest date planned that working on this item will start. (Date) | prj_early_start |
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_prj_per_oid | itsm_persons
Estimated finish, Date and time that the item is expected to be finished. (Date) |  |
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | prj_poo_oid | rep_codes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, History lines (Set of History line Project) |  | itsm_historylines_projects hpj_prj_oid
ID, Identification number. Used to identify the item when communicating information about the item. (ID, Number 18) | prj_id |
Impact, The impact reflects how much the work of the caller is impaired or in what extent the work of other people is impaired. (Reference to Impact, Number 18) | prj_imp_oid | itsm_codes
Information, Full information of this item. Should contain all necessary information needed to handle the item or work on the item. (Text 4000) | itsm_prj_information pif_information |
Initiator, The person who is responsible for initiating approval for this item. (Reference to Person, Number 18) | prj_initiator_per_oid | itsm_persons
Late finish, The latest date planned to finalize work on this item. (Date) | prj_late_finish |
Late start, The latest date planned to start work on this item. (Date) | prj_late_start |
Manager, Organization manager (Reference to Person, Number 18) | prj_proj_man_oid | itsm_persons
Max. duration, Maximum amount of time allowed for working on the current item. (Number 9) | prj_maximum_duration |
Object ID (Object ID, Number 18) | prj_oid |
Open duration, Actual time the current item is opened. (Number 9) |  |
Planned Cost, Planned total cost of handling this item. (Number 64) | prj_planned_cost |
Planned Duration, Planned duration of work on this item. (Number 9) | prj_plan_duration |
Planned Finish, Date planned to finalize work on this item. (Date) | prj_plan_finish |
Planned Start, Planned date to start working on this item. (Date) | prj_plan_start |
Priority, The priority reflects the urgency for quick resolution of the item. (Reference to Priority, Number 18) | prj_pri_oid | itsm_codes
Registered, Date and time the current item was created. (Date) |  |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | prj_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | prj_cre_acc_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | prj_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | prj_mod_acc_oid | rep_accounts
Remain duration, Remaining duration of work on this item, calculated from the current date to the planned finish date. (Number 9) | itsm_changes cha_remainduration |
Requestor, The person who requested this item. This person is excluded from voting for approval for this item. (Reference to Person, Number 18) | prj_requestor_per_oid | itsm_persons
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | prj_sourceid |
Status, Status of current project (Reference to Project Status, Number 18) | prj_sta_oid | rep_codes
Status (Service Today) (Reference to Status, Number 18) | prj_sta_oid | rep_codes
Template (Reference to Template, Number 18) | prj_tem_oid | rep_templates
To deadline, Amount of time till deadline is reached (Number 9) |  |

Project Category (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Attributes (Set of Attributes per category) |  | rep_attr_per_category apc_cat_oid
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Children, List of children for this code. (Set of Kernel Code Hierarchical) |  | rep_codes rcd_rcd_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Kernel Code Hierarchical, Number 18) | rcd_rcd_oid | rep_codes
Project, Category of current project (Set of Project) |  | itsm_projects prj_cat_oid
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Project Status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
State (Reference to State, Number 18) | itsm_workflow_statuses wos_sta_oid | itsm_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Question (table: itsm_checklist_questions properties: only detail, code, cached)

Description | Column | Related to
--- | --- | ---
Checklist (Reference to Checklist, Number 18) | cqu_cod_oid | itsm_codes
Description (Text 255) | cqu_description |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | cqu_oid |
Option Button Question (Boolean, Number 1) | cqu_buttonquestion |
Ordering (Number 9) | cqu_ordering |
Suggestion No (Text 255) | cqu_suggestionno |
Suggestion Yes (Text 255) | cqu_suggestionyes |
Template (Reference to Template, Number 18) | cqu_tem_oid | rep_templates
Text Question (Boolean, Number 1) | cqu_textquestion |

Receiver Organizations On Agreement (table: itsm_sc_rec_organizations properties: only detail)

Description | Column | Related to
--- | --- | ---
Agreement, Receiver organizations (Reference to Agreement, Number 18) | sro_sla_oid | itsm_service_level_agreements
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | sro_oid |
Organizations, Receiver organizations (Reference to Organization, Number 18) | sro_org_oid | itsm_organizations
Template (Reference to Template, Number 18) | sro_tem_oid | rep_templates

Receiver Persons On Agreement (table: itsm_sc_rec_persons properties: only detail)

Description | Column | Related to
--- | --- | ---
Agreement, Receiver persons (Reference to Agreement, Number 18) | srp_sla_oid | itsm_service_level_agreements
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | srp_oid |
Person, Receiver person (Reference to Person, Number 18) | srp_per_oid | itsm_persons
Template (Reference to Template, Number 18) | srp_tem_oid | rep_templates

Report Type (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Service (table: itsm_services properties: authorizable)

Description | Column | Related to
--- | --- | ---
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | srv_attachment_exists |
Blocked (Boolean, Number 1) | srv_blocked |
Checklist (Reference to Service Checklist, Number 18) | srv_cod_oid | itsm_codes
Child services, List of all direct child services of this service. By adding (removing) a service to (from) the list, a hierarchical tree of services is created or modified. (Set of Service) |  | itsm_services srv_srv_oid
Description (Text 4000) | itsm_srv_description srd_description |
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_srv_per_oid | itsm_persons
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | srv_pool_cod_oid | rep_codes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, History lines (Set of History line Service) |  | itsm_historylines_service hsr_srv_oid
ID, ID of this service (ID, Number 18) | srv_id |
Managed CIs, List of the configuration items (CIs) that are managed by this operations management service. By adding (removing) a CI to (from) the list, this service will (will not) manage the CI. (Set of Configuration Item) |  | itsm_configuration_items cit_mgmt_service_oid
Name, Name of this service (Text 80) | srv_name |
Object ID (Object ID, Number 18) | srv_oid |
Parent service, The parent service. Select a service from the list. By selecting a parent a hierarchical tree structure of services is created. (Reference to Service, Number 18) | srv_srv_oid | itsm_services
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | srv_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | srv_cre_acc_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | srv_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | srv_mod_acc_oid | rep_accounts
Service calls (Set of Service call) |  |
Service Level Agreement, Service of this service level agreement (Set of Service Level Agreement) |  | itsm_service_level_agreements sla_srv_oid
Service type, Specify the service type: Business services are typically services provided to customers. Operations management services define the management of CIs. Underpinning services typically specify maintenance services supporting operations management services. (Reference to Service type, Number 18) | srv_typ_oid | itsm_codes
SN Name (Text 255) | srv_sn_name |
SN Socket Address (Reference to Service Navigator Server, Number 18) | srv_sn_sockaddr | itsm_codes
SN Status (Text 40) |  |
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | srv_sourceid |
Status, Status of this service (Reference to Service Status, Number 18) | srv_status_cod_oid | rep_codes
Supported CIs, List of all configuration items (CIs) that are supported by this underpinning service. By adding (removing) a CI to (from) the list, this service will (will not) support the CI. (Set of Configuration Item) |  | itsm_configuration_items cit_underpin_service_oid
Template (Reference to Template, Number 18) | srv_tem_oid | rep_templates
Underpinned by services, List of all underpinning (UP) services that underpin this operations management service. By adding (removing) a UP service to (from) the list, that UP service will (will not) underpin this operations management service. (Set of Underpinning service relation) |  | itsm_underpin_serv_relations usr_service_to_oid
Underpinned services, List of all operations management (OM) services that are underpinned by this underpinning (UP) service. By adding (removing) an OM service to (from) the list, this UP service will (will not) underpin the OM service. (Set of Underpinning service relation) |  | itsm_underpin_serv_relations usr_service_from_oid
Used by these Business Services, List of all business services that make use of this service. By adding (removing) a business service to (from) the list, that service will (will not) make use of this service. (Set of Service relation) |  | itsm_serv_relations svr_service_to_oid
Used CIs, List of all configuration items (CIs) that are used by this service as a resource. By adding (removing) a CI to (from) the list, that CI will (will not) be used by this service. (Set of Configuration Item on Service) |  | itsm_service_cis sci_srv_oid
Used services, List of all business services that are used by this service. By adding (removing) a business service to (from) the list, that service will (will not) be used by the this service. (Set of Service relation) |  | itsm_serv_relations svr_service_from_oid

Service call (table: itsm_servicecalls properties: authorizable)

Description | Column | Related to
--- | --- | ---
Actual Cost, The actual costs of handling this item. (Number 64) | ser_actualcost |
Actual Duration, Total time worked on this item. (Number 9) | ser_actualduration |
Actual Finish, The date work on this item finished. (Date) | ser_actualfinish |
Actual Start, The date working on this item was started. (Date) | ser_actualstart |
Analyzed data Service call (Set of Analyzed data Service call) |  | itsm_analyzed_data agd_ser_oid
#Approved approvers (Number 9) | ser_apt_nrofapproversapproved |
#Approvers Required, The number of approvers who need to approve to get approval for this item. (Number 9) | ser_apt_nrofapproversrequired |
Approval group, Workgroup of the approvers (Reference to Workgroup, Number 18) | ser_apt_wog_oid | itsm_workgroups
Approval Status, The status of the approval. Only at status Active it possible to vote for approval (Reference to Approval Status, Number 18) | ser_apt_status | itsm_codes
Approval Votes, People responsible for voting for approval (Set of Approval Vote) |  | itsm_approver_votes apv_apt_oid
Deadline, The deadline which before all approvers have to vote. If the deadline is passed and the approval result is still incomplete the result will be set to Rejected (Date) | ser_apt_deadline |
Description, Approval Description (Text 80) | ser_apt_description |
NrOfApprovers (Number 9) | ser_apt_nrofapprovers |
Result, This field reflects the state of the approval for this item (Text 40) |  |
Strategy, The used strategy for this approval (Text 255) |  |
Assignment Priority, Priority of assignment The priority shows the importance of quick handling of the assignment. The higher the priority, the faster the assignment must be addressed. (Reference to Assignment Priority, Number 18) | ser_assignpriority | itsm_codes
Assignment Status, The status shows the progress of the responsible person's work towards completion. (Reference to Assignment Status, Number 18) | ser_assignstatus | itsm_codes
External Deadline, The latest date the external organization is expected to complete and deliver work they are made responsible for . (Date) | ser_assign_extdeadline |
From person, Person who created the current assignment. This person assigned the current item to another person. (Reference to Person, Number 18) | ser_ass_per_from_oid | itsm_persons
From workgroup, The workgroup of the person who created the current assignment. (Reference to Workgroup, Number 18) | ser_ass_wog_from_oid | itsm_workgroups
Information from sender, From this field the receiver of the service call can review additional information about the service call that was added by the sender (Text 4000) | itsm_ser_ass_information sai_ass_information |
Information to receiver, In this field the sender who assigns the service call to a receiver can add information about the background of the service call, some additional information, and why it is sent to this receiver (Text 4000) |  |
Reference #, Reference number used to communicate information with the responsible external organization. (Text 50) | ser_assign_referencenumber |
To external Organization, External organization responsible for handling the item. (Reference to Organization, Number 18) | ser_ass_contr_out_org | itsm_organizations
To external Person, Employee of the external organization responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | ser_ass_contr_out_per | itsm_persons
To person, Person made responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | ser_ass_per_to_oid | itsm_persons
To workgroup, Work group of the person currently responsible for this item. (Reference to Workgroup, Number 18) | ser_ass_wog_oid | itsm_workgroups
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | ser_attachment_exists |
Caller, The caller. Person who supplied the information registered in this service call. (Reference to Person, Number 18) | ser_caller_per | itsm_persons
Category, The service call's category. The category groups service calls in a hierarchical structure. In this structure items are grouped based on their likely or apparent cause. Click Category and select a category from the tree view. (Reference to Service call Category, Number 18) | ser_cat_oid | rep_codes
Category (Service Today) (Reference to Category, Number 18) | ser_cat_oid | rep_codes
Classification, Classification reflects an assessment of the service call after resolution. Click Classification and select a classification code from the tree view. (Reference to Service call Classification, Number 18) | ser_cla_oid | itsm_codes
Closure code, The closure code shows the reason why the status of the service call is closed or not worked on anymore. (Reference to Service call Closure code, Number 18) | ser_clo_oid | itsm_codes
Configuration Item, The configuration item that is subject of the current item. (Reference to Configuration Item, Number 18) | ser_cit_oid | itsm_configuration_items
Deadline, The latest date the results and work related to this item must be completed and delivered. (Date) | ser_deadline |
Deadline Service, Shows the Service from which the Deadline has been calculated. (Reference to Service, Number 18) | ser_deadline_srv_oid | itsm_services
Description, Description of current item. The description 's a summary of the information field. The description is used for later retrieval and analyses. (Text 80) | ser_description |
Early finish, The earliest date planned that work on this item will be finalized. (Date) | ser_earlyfinish |
Early start, The earliest date planned that working on this item will start. (Date) | ser_earlystart |
E-mails (Set of E-mail Service Call) |  | itsm_emailsc esc_ser_oid
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_ser_per_oid | itsm_persons
Estimated finish, Date and time that the item is expected to be finished. (Date) |  |
FAQ Group, Frequently Asked Question group. Click FAQ group to select a group. The FAQ group identifies a service call as a typical question and its answer. Primarily used in Self-service Pages. (Reference to FAQ Group, Number 18) | ser_faq_oid | itsm_codes
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | ser_poo_oid | rep_codes
Frequently Asked Question (Boolean, Number 1) | ser_frequentlyaskedquestion |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, Service call history lines. List of changes applied to the service call's information. (Set of History line Service call) |  | itsm_historylines_servicecall hsc_ser_oid
ID, Identification number. Used to identify the item when communicating information about the item. (ID, Number 18) | ser_id |
Impact, The impact reflects how much the work of the caller is impaired or in what extent the work of other people is impaired. (Reference to Impact, Number 18) | ser_imp_oid | itsm_codes
Information, Full information of this item. Should contain all necessary information needed to handle the item or work on the item. (Text 4000) | itsm_ser_information sei_information |
Initiator, The person who is responsible for initiating approval for this item. (Reference to Person, Number 18) | ser_initiator_per_oid | itsm_persons
Late finish, The latest date planned to finalize work on this item. (Date) | ser_latefinish |
Late start, The latest date planned to start work on this item. (Date) | ser_latestart |
Max. duration, Maximum amount of time allowed for working on the current item. (Number 9) | ser_maximumduration |
Medium, The means used to supply the information registered in the service call. For example, telephone, fax, or e-mail message. (Reference to Medium, Number 18) | ser_med_oid | itsm_codes
Object ID (Object ID, Number 18) | ser_oid |
Open duration, Actual time the current item is opened. (Number 9) |  |
Organization, The company or organization the caller works for. (Reference to Organization, Number 18) | ser_caller_org | itsm_organizations
Planned Cost, Planned total cost of handling this item. (Number 64) | ser_plannedcost |
Planned Duration, Planned duration of work on this item. (Number 9) | ser_planduration |
Planned Finish, Date planned to finalize work on this item. (Date) | ser_planfinish |
Planned Start, Planned date to start working on this item. (Date) | ser_planstart |
Priority, The priority reflects the urgency for quick resolution of the item. (Reference to Priority, Number 18) | ser_pri_oid | itsm_codes
Registered, Date and time the current item was created. (Date) |  |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Relations, List of items related to this service call. (Set of Service Event Relation) |  | itsm_service_relations sre_ser_oid
Remain duration, Remaining duration of work on this item, calculated from the current date to the planned finish date. (Number 9) | itsm_changes cha_remainduration |
Requestor, The person who requested this item. This person is excluded from voting for approval for this item. (Reference to Person, Number 18) | ser_requestor_per_oid | itsm_persons
Service, The service is supplied to customers through a service level agreement. (Reference to Service, Number 18) | ser_srv_oid | itsm_services
Service Level, A service level contains relations with one or more multiple impact-priority dependencies and a schedule. (Reference to Service Level, Number 18) | ser_sel_oid | itsm_service_level
SLA, The service level agreement combines the service with a service level in order to supply the service to a receiver. (Reference to Service Level Agreement, Number 18) | ser_sla_oid | itsm_service_level_agreements
SLA Report Negative Indications (Set of SLA Report Negative Indications) |  | itsm_sla_report_neg_indication rni_ser_oid
Solution, Proposed or accepted and working solution given or answer returned to the caller of the service call. (Text 4000) | itsm_ser_solution scs_solution |
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | ser_sourceid |
Status, Status of this service call. Shows the position of the service call in its lifecycle. The lifecycle of a service call starts with being created and ends with being removed. (Reference to Service call Status, Number 18) | ser_sta_oid | rep_codes
Status (Service Today) (Reference to Status, Number 18) | ser_sta_oid | rep_codes
Subcontract call from incident (Reference to Incident, Number 18) | scc_from_inc_oid | itsm_incidents
Subcontract call from servicecall (Reference to Service call, Number 18) | scc_from_ser_oid | itsm_servicecalls
Subcontract calls (Set of Service call) |  | itsm_servicecalls scc_from_ser_oid
Template (Reference to Template, Number 18) | ser_tem_oid | rep_templates
To deadline, Amount of time till deadline is reached (Number 9) |  |
Wait for Work Order Completion (Boolean, Number 1) | ser_waitforwo |
Workaround, Suggested workaround to be used until a definite solution is found. (Text 4000) | itsm_ser_workaround scw_workaround |
Work orders, List of workorders related to this service call. Work orders describe work resulting from the service call. (Set of Work order) |  | itsm_workorders wor_ser_oid

Service call Category (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Attributes (Set of Attributes per category) |  | rep_attr_per_category apc_cat_oid
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Children, List of children for this code. (Set of Kernel Code Hierarchical) |  | rep_codes rcd_rcd_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Kernel Code Hierarchical, Number 18) | rcd_rcd_oid | rep_codes
Service calls, List of all service calls that are registered with the current category. (Set of Service call) |  | itsm_servicecalls ser_cat_oid
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Service call Classification (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Checklist (Reference to Classification Checklist, Number 18) | cod_checklist_oid | itsm_codes
Children, List of children for this code. (Set of Code hierarchical) |  | itsm_codes cod_cod_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Code hierarchical, Number 18) | cod_cod_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Service call Closure code (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Children, List of children for this code. (Set of Code hierarchical) |  | itsm_codes cod_cod_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Code hierarchical, Number 18) | cod_cod_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Service call Priority Duration setting (table: itsm_prioritydurationsettings properties: code, cached)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Max. duration (Number 9) | pds_maximumduration |
Object ID (Object ID, Number 18) | pds_oid |
Priority, Priority code. Select a priority code from the list, then enter the time allowed for a service call registered with this priority in hours and minutes. (Reference to Priority, Number 18) | pds_priority | itsm_codes
Template (Reference to Template, Number 18) | pds_tem_oid | rep_templates

Service call Status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
State (Reference to State, Number 18) | itsm_workflow_statuses wos_sta_oid | itsm_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Service Checklist (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Questions (Set of Question) |  | itsm_checklist_questions cqu_cod_oid
Services (Set of Service) |  | itsm_services srv_cod_oid
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Service Desk Metric (table: itsm_servicedeskmetrics properties: only detail)

Description | Column | Related to
--- | --- | ---
Description, The name of this metric. Is used in the list of metrics in the SLA (Text 255) | sdm_description |
Evaluate for each receiving organization, Select this to calculate results for each customer organization that received service based on the current SLA. If the service hours of the SLA are defined in the time zone of the supplier, then this option has no effect. (Boolean, Number 1) | sdm_evaluateforeachcustomer |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Incident, Impact code of incidents that determines whether the incident is included in the availability calculation. If the impact code of a incident is equal or higher than the given impact code, then the incident designates unavailability for the current metric. (Reference to Impact, Number 18) | sdm_cod_oid | itsm_codes
Include Incidents only, Select this option to only include incidents in the metric calculation. (Boolean, Number 1) | sdm_includeincidentsonly |
Include Service calls and Incidents, Select this option to include service calls and incidents that apply to the current SLA in the metric calculation. (Boolean, Number 1) | sdm_includeservicecallsandinci |
Include Service calls only, Select this option to only include service calls in the metric calculation. (Boolean, Number 1) | sdm_includeservicecallsonly |
Metric Type, Type of metric. Determines the settings used in the metric calculation. (Reference to Metric Type, Number 18) | sdm_metrictype | itsm_codes
Minimum Availability, Availability performance indicator, if availability is less than the given value, then the availability violation field will have true as value (resulting in a checked checkbox in the results table view). (Number 9) | sdm_minimumavailability |
Minimum MTBF, Minimum MTBF indicator, if the MTBF is less than the given time, then the MTBF violation field will contain true as value (resulting in a checked checkbox in the results table view). (Number 9) | sdm_minimummtbf |
of Calendar Hours, Choose this option to calculate the metric based on calendar hours. All occurrences of unavailability will be included in the calculation. (Boolean, Number 1) | sdm_ofcalendarhours |
of Service Hours, Choose this option to calculate the metric based on service hours. Only the occurrences of unavailability that happened during service hours will be included in the calculation. (Boolean, Number 1) | sdm_ofservicehours |
Object ID (Object ID, Number 18) | sdm_oid |
Daily, Choose this option to calculate the metric every day, or on a regular interval of days. (Boolean, Number 1) | sdm_recurrencedaily |
End, End of the period in which the metric is calculated. (Date) | sdm_recurrenceend |
Every (Number 9) | sdm_every |
Every Occurrence (Number 9) | sdm_everyoccurrence |
Month (Reference to Month, Number 18) | sdm_month_rcd_oid | rep_codes
Monthly, Choose this option to calculate the metric in a monthly pattern. (Boolean, Number 1) | sdm_recurrencemonthly |
Monthly Day, Supply the month and the day of the month that the metric must be calculated each year. (Boolean, Number 1) | sdm_monthlyday |
Next Occurrence, Shows the next time that this metric was calculated based on the reccurrence pattern. (Date) |  |
Previous Occurrence, Shows the last time this metric was calculated. (Date) |  |
Relative Occurrence (Reference to Relative Occurrence, Number 18) | sdm_relative_occ_oid | rep_codes
Start, Start of the period in which the metric is calculated. (Date) | sdm_recurrencestart |
Summary, Gives a summary of the given recurrence pattern. (Text 255) |  |
Time, The time that the metric must be calculated. (Date) | sdm_time |
Week Day (Reference to Week Day, Number 18) | sdm_day_rcd_oid | rep_codes
Weekly, Choose this option to calculate the metric in a weekly pattern. (Boolean, Number 1) | sdm_recurrenceweekly |
Yearly, Choose this option to calculate the metric in a yearly pattern. (Boolean, Number 1) | sdm_recurrenceyearly |
Yearly Every (Date) | sdm_yearlyevery |
Service call, Impact code of service calls that determines whether the service call is included in the availability calculation. If the impact code of a service call is equal or higher than the given impact code, then the service call designates unavailability. (Reference to Impact, Number 18) | sdm_failureimpactservicecall | itsm_codes
Service Level Agreement (Reference to Service Level Agreement, Number 18) | sdm_sla_oid | itsm_service_level_agreements
SLA Report Results, Calculation results of the current metric. (Set of SLA Report Results) |  | itsm_slareportresults srr_sdm_oid
Template (Reference to Template, Number 18) | sdm_tem_oid | rep_templates

Service Event Relation (table: itsm_service_relations properties: only detail)

Description | Column | Related to
--- | --- | ---
Change, Change related to this item. Use the lookup item button to find or create a change. (Reference to Change, Number 18) | sre_cha_oid | itsm_changes
From entity (Reference to Item, Number 18) | sre_ent_oid | ifc_entities
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Incident, Incident related to this item. Use the lookup item button to find or create an incident. (Reference to Incident, Number 18) | sre_inc_oid | itsm_incidents
Object ID (Object ID, Number 18) | sre_oid |
Problem, Problem related to this item. Use the lookup item button to find or create a problem. (Reference to Problem, Number 18) | sre_pro_oid | itsm_problems
Relation type, Type of the relation between the items. Relations are two way. For example, a problem 'causes' the incident and the incident is 'caused by' the problem. Select the relation type that best describes the situation. (Reference to Service Event Relation Type, Number 18) | sre_rty_oid | itsm_codes
Reverse Relation (Reference to Service Event Relation Type, Number 18) | sre_revrty_oid | itsm_codes
Service call, Service call related to this item. Use the lookup item button to find or create a service call. (Reference to Service call, Number 18) | sre_ser_oid | itsm_servicecalls
Template (Reference to Template, Number 18) | sre_tem_oid | rep_templates

Service Event Relation Type (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Ordering, Ordering number for the current code. The lower the number the higher the code will be shown in lists. Once a code is used, do not modify the number. (Number 9) | cod_ordering |
Reverse Relation, Relation type used when the relation is viewed from the related item. (Reference to Relation type, Number 18) | cod_reverse_rel_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Service Level (table: itsm_service_level properties: code, authorizable, cached)

Description | Column | Related to
--- | --- | ---
Blocked (Boolean, Number 1) | sel_blocked |
Default, Default service level (Boolean, Number 1) | sel_default |
Description (Text 80) | sel_description |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon (Icon name, Text 255) | sel_icon |
Impact Priority Setting, Impact-priority settings (Set of Impact Priority Setting) |  | itsm_priorityimpactsettings pis_sel_oid
Name (Text 50) | sel_name |
Object ID (Object ID, Number 18) | sel_oid |
Service calls (Set of Service call) |  |
Support Hours, Support hours (Set of Support Hours) |  | itsm_support_hours sho_sel_oid
Template (Reference to Template, Number 18) | sel_tem_oid | rep_templates
Weight, A unique value, indicating this Service Level's weight compared to other Service Levels. (Number 9) | sel_weight |

Service Level Agreement (table: itsm_service_level_agreements properties: authorizable)

Description | Column | Related to
--- | --- | ---
Actual Finish, Date current service level agreement was first active or will be active. (Date) | sla_actualfinish |
Actual Start, Date current service level agreement will expire. (Date) | sla_actualstart |
Applied time zone, Choose if the timezone must be used from the provider or from the receiver (Boolean, Number 1) | sla_timezonefordeadlinecalc |
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | sla_attachment_exists |
Blocked (Boolean, Number 1) | sla_blocked |
Description, Description of the service level agreement. (Text 80) | sla_description |
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_sla_per_oid | itsm_persons
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | sla_pool_cod_oid | rep_codes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, History lines (Set of History line Service Level Agreement) |  | itsm_historylines_sla hsa_sla_oid
ID, ID of the service level agreement. (ID, Number 18) | sla_id |
Information, Full information of this service level agreement. (Text 4000) | itsm_sla_information sli_information |
Name, Name of the service level agreement. (Text 50) | sla_name |
Object ID (Object ID, Number 18) | sla_oid |
Organizations, Organization that is the receiving party of the service level agreement. (Set of Receiver Organizations On Agreement) |  | itsm_sc_rec_organizations sro_sla_oid
OVIS Metric (Set of OVIS Metric) |  | itsm_internetservicesmetrics ism_sla_oid
Persons, Person who is the receiving party of the service level agreement. (Set of Receiver Persons On Agreement) |  | itsm_sc_rec_persons srp_sla_oid
Price, Price or direct cost of the service level agreement. (Number 64) | sla_price |
Provider Organization, Organization that offers the service to the receiving parties of the service level agreement. (Reference to Organization, Number 18) | sla_pro_org_oid | itsm_organizations
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | sla_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | sla_cre_acc_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | sla_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | sla_mod_acc_oid | rep_accounts
Service (Reference to Service, Number 18) | sla_srv_oid | itsm_services
Service calls (Set of Service call) |  |
Service Desk Metrics (Set of Service Desk Metric) |  | itsm_servicedeskmetrics sdm_sla_oid
Service Level, Service level (Reference to Service Level, Number 18) | sla_sel_oid | itsm_service_level
SLA Report Results (Set of SLA Report Results) |  | itsm_slareportresults srr_sla_oid
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | sla_sourceid |
Status, Status of this service level agreement (Reference to SLA Status, Number 18) | sla_status_cod_oid | rep_codes
Template (Reference to Template, Number 18) | sla_tem_oid | rep_templates
To external Organization (Reference to Organization, Number 18) | sla_external_org_oid | itsm_organizations
To external Person (Reference to Person, Number 18) | sla_external_per_oid | itsm_persons
To person (Reference to Person, Number 18) | sla_per_oid | itsm_persons
To workgroup (Reference to Workgroup, Number 18) | sla_wog_oid | itsm_workgroups

Service Navigator Code (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
SN Status (Text 80) | cod_servicenavstatus |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Service Navigator Server (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Service relation (table: itsm_serv_relations properties: only detail)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | svr_oid |
Service from, The 'providing' service of the uses/used by relation between two services. The service selected here 'uses' the service selected in the 'service to' field. (Reference to Service, Number 18) | svr_service_from_oid | itsm_services
Service to, The 'receiving' service of the uses/used by relation between two services. The service selected here is 'used by' the service selected in the 'service from' field. (Reference to Service, Number 18) | svr_service_to_oid | itsm_services
Template (Reference to Template, Number 18) | svr_tem_oid | rep_templates

Service Status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Service type (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Severity (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Ordering, Ordering number for the current code. The lower the number the higher the code will be shown in lists. Once a code is used, do not modify the number. (Number 9) | cod_ordering |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

SLA Report Negative Indications (table: itsm_sla_report_neg_indication properties: only detail)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Incident (Reference to Incident, Number 18) | rni_inc_oid | itsm_incidents
Object ID (Object ID, Number 18) | rni_oid |
Service call (Reference to Service call, Number 18) | rni_ser_oid | itsm_servicecalls
SLA Report Results (Reference to SLA Report Results, Number 18) | rni_srr_oid | itsm_slareportresults
Template (Reference to Template, Number 18) | rni_tem_oid | rep_templates

SLA Report Results (table: itsm_slareportresults properties: only detail)

Description | Column | Related to
--- | --- | ---
Availability, Result of the availability calculation. (Number 9) | srr_availability |
Availability Violation, If checked, the result indicates availability that is less than the minimum availability indicated in the metric. (Boolean, Number 1) | srr_availabilityviolation |
Average pickup time, Average time that service calls or incidents were picked up to be handled. If pick-up time is not defined in report settings, then there are no results shown. (Number 9) | srr_averagepickuptime |
Average solution time, Average time that service calls or incidents were solved. If solution time is not defined in report settings, then there are no results shown. (Number 9) | srr_averagesolutiontime |
Evaluation Date, Date when the result was generated. (Date) | srr_evaluationdate |
Evaluation End, End of the period of which the metric is calculated. In recurring evaluations, this is equal to Date. (Date) | srr_evaluationend |
Evaluation Start, Start of the period of which the metric is calculated. In recurring evaluations, this is the moment of the previous evaluation. (Date) | srr_evaluationstart |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Metric, Description of the metric that supplied this result. (Reference to Service Desk Metric, Number 18) | srr_sdm_oid | itsm_servicedeskmetrics
MTBF, Mean time between failures. Result of MTBF calculation. (Number 9) | srr_mbtf |
MTBF Violation, If checked, the result indicates MTBF that is less than the minimum MTBF indicated in the metric. (Boolean, Number 1) | srr_mtbfviolation |
Number of Calls, The number of calls to which the metric applied. (Number 9) | srr_numberofcalls |
Number of Calls over duration, The number of calls to which the metric applied and that have duration longer than the maximum duration allowed for the call. (Number 9) | srr_numberofcallsoverduration |
Number of Calls passed deadline, The number of calls to which the metric applied and that have a actual finish later than the deadline. (Number 9) | srr_numberofcallspasseddeadlin |
Number of Calls with outage, The number of calls to which the metric applied and that have an impact equal or higher than the failure impact code of the metric. (Number 9) | srr_numberofcallswithoutage |
Object ID (Object ID, Number 18) | srr_oid |
Organization, Customer organization that received the service based on this SLA. Only applicable if the metric was evaluated for each customer. (Reference to Organization, Number 18) | srr_org_oid | itsm_organizations
Pre-run, If checked, this result is created as a result of a pre-run evaluation. Pre-run evaluation results can be deleted. Official evaluation results cannot be deleted throught the user interface. (Boolean, Number 1) | srr_prerun |
Service Level Agreement (Reference to Service Level Agreement, Number 18) | srr_sla_oid | itsm_service_level_agreements
SLA Report Negative Indications, List of service calls and incidents that indicate unavailability. (Set of SLA Report Negative Indications) |  | itsm_sla_report_neg_indication rni_srr_oid
Template (Reference to Template, Number 18) | srr_tem_oid | rep_templates

SLA Status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

State (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Accountable (Boolean, Number 1) | cod_isaccountable |
Active (Boolean, Number 1) | cod_isactive |
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Closed (Boolean, Number 1) | cod_isclosed |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Idle (Boolean, Number 1) |  |
Not Accountable (Boolean, Number 1) | cod_isnotaccountable |
Object ID (Object ID, Number 18) | cod_oid |
Open (Boolean, Number 1) |  |
Ordering, Ordering number for the current code. The lower the number the higher the code will be shown in lists. Once a code is used, do not modify the number. (Number 9) | cod_ordering |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Strategy (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Subcontract relation (table: itsm_servicecalls properties: only detail)

Description | Column | Related to
--- | --- | ---
Subcontract call from incident (Reference to Incident, Number 18) | scc_from_inc_oid | itsm_incidents
Subcontract call from servicecall (Reference to Service call, Number 18) | scc_from_ser_oid | itsm_servicecalls

Suffix (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Support Hours (table: itsm_support_hours properties: only detail, cached)

Description | Column | Related to
--- | --- | ---
From, Support hours From (Number 9) | sho_from |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | sho_oid |
Openings Schedule (Reference to Openings Schedule, Number 18) | sho_osc_oid | itsm_openings_schedules
Service Level, A service level contains relations with one or more multiple impact-priority dependencies and a schedule. (Reference to Service Level, Number 18) | sho_sel_oid | itsm_service_level
Template (Reference to Template, Number 18) | sho_tem_oid | rep_templates
To, Support hours To (Number 9) | sho_to |

Telephone (table: itsm_telephones properties: only detail)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Number, Telephone number. (Text 40) | tel_number |
Object ID (Object ID, Number 18) | tel_oid |
Organization (Reference to Organization, Number 18) | tel_org_oid | itsm_organizations
Person (Reference to Person, Number 18) | tel_per_oid | itsm_persons
Primary, Check this to be able to select the telephone number in a view. (Boolean, Number 1) | tel_primary |
Telephone type, The intended use of the telephone number. (Reference to Telephone type, Number 18) | tel_typ_oid | itsm_codes
Template (Reference to Template, Number 18) | tel_tem_oid | rep_templates

Telephone type (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Title (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Underpinning service relation (table: itsm_underpin_serv_relations properties: only detail)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | usr_oid |
Service from, The ''providing'' service of the underpins/underpinned by relation between two services. The service selected here ''underpins'' the service selected in the ''service to'' field. (Reference to Service, Number 18) | usr_service_from_oid | itsm_services
Service to, The ''receiving'' service of the underpins/underpinned by relation between two services. The service selected here is ''underpinned by'' the service selected in the ''service from'' field. (Reference to Service, Number 18) | usr_service_to_oid | itsm_services
Template (Reference to Template, Number 18) | usr_tem_oid | rep_templates

Workgroup (table: itsm_workgroups properties: authorizable)

Description | Column | Related to
--- | --- | ---
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | wog_attachment_exists |
Blocked (Boolean, Number 1) | wog_notselectable |
Child Workgroups, Child work groups defined for the current work group. (Set of Workgroup) |  | itsm_workgroups wog_parent
Configuration items (Set of Configuration Item) |  | itsm_configuration_items cit_admin_wog_oid
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_wog_per_oid | itsm_persons
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | wog_poo_oid | rep_codes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, Work group history lines. List of changes applied to the work group's information. (Set of History line Workgroup) |  | itsm_historylines_workgroup ihw_wog_oid
Holidays (Reference to HolidayCalendar, Number 18) | wog_hcr_oid | itsm_holiday_calendars
Member, List of members of the current workgroup. The listed persons are specialists connected to the current workgroup. (Set of Member) |  | itsm_members mem_wog_oid
Name, Name of the current workgroup. (Text 50) | wog_name |
Object ID (Object ID, Number 18) | wog_oid |
Opening Hours (Reference to Openings Schedule, Number 18) | wog_osc_oid | itsm_openings_schedules
Parent, The parent workgroup of the current workgroup. By relating the workgroup to a parent, the workgroup is subordinated in a hierarchical structure. (Reference to Workgroup, Number 18) | wog_parent | itsm_workgroups
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | wog_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | wog_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Search code, Work group search code. Used as short hand to retrieve the work group information. (Text 50) | wog_searchcode |
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | wog_sourceid |
Status, Status of this workgroup. Shows the position of the workgroup in its lifecycle. The lifecycle of a workgroup starts with being created and ends with being removed. (Reference to Workgroup Status, Number 18) | wog_sta_oid | rep_codes
Template (Reference to Template, Number 18) | wog_tem_oid | rep_templates
Time Zone (Reference to Time Zones, Number 18) | wog_tmz_oid | rep_time_zones

Workgroup Status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Work order (table: itsm_workorders properties: authorizable)

Description | Column | Related to
--- | --- | ---
Actual Cost, The actual costs of handling this item. (Number 64) | wor_actualcost |
Actual Duration, Total time worked on this item. (Number 9) | wor_actualduration |
Actual Finish, The date work on this item finished. (Date) | wor_actualfinish |
Actual Start, The date working on this item was started. (Date) | wor_actualstart |
Analyzed data Workorder (Set of Analyzed data Workorder) |  | itsm_analyzed_data agd_wor_oid
Applied Calendar (Reference to Work Order Calculation Type, Number 18) | wor_cod_oid | itsm_codes
#Approved approvers (Number 9) | wor_apt_nrofapproversapproved |
#Approvers Required, The number of approvers who need to approve to get approval for this item. (Number 9) | wor_apt_nrofapproversrequired |
Approval group, Workgroup of the approvers (Reference to Workgroup, Number 18) | wor_apt_wog_oid | itsm_workgroups
Approval Status, The status of the approval. Only at status Active it possible to vote for approval (Reference to Approval Status, Number 18) | wor_apt_status | itsm_codes
Approval Votes, People responsible for voting for approval (Set of Approval Vote) |  | itsm_approver_votes apv_apt_oid
Deadline, The deadline which before all approvers have to vote. If the deadline is passed and the approval result is still incomplete the result will be set to Rejected (Date) | wor_apt_deadline |
Description, Approval Description (Text 80) | wor_apt_description |
NrOfApprovers (Number 9) | wor_apt_nrofapprovers |
Result, This field reflects the state of the approval for this item (Text 40) |  |
Strategy, The used strategy for this approval (Text 255) |  |
Assignment Priority, Priority of assignment The priority shows the importance of quick handling of the assignment. The higher the priority, the faster the assignment must be addressed. (Reference to Assignment Priority, Number 18) | wor_assignpriority | itsm_codes
Assignment Status, The status shows the progress of the responsible person's work towards completion. (Reference to Assignment Status, Number 18) | ass_assignstatus | itsm_codes
External Deadline, The latest date the external organization is expected to complete and deliver work they are made responsible for . (Date) | wor_assign_extdeadline |
From person, Person who created the current assignment. This person assigned the current item to another person. (Reference to Person, Number 18) | ass_per_from_oid | itsm_persons
From workgroup, The workgroup of the person who created the current assignment. (Reference to Workgroup, Number 18) | ass_wog_from_oid | itsm_workgroups
Information from sender, From this field the receiver of the service call can review additional information about the service call that was added by the sender (Text 4000) | itsm_wor_ass_information wai_ass_information |
Information to receiver, In this field the sender who assigns the service call to a receiver can add information about the background of the service call, some additional information, and why it is sent to this receiver (Text 4000) |  |
Reference #, Reference number used to communicate information with the responsible external organization. (Text 50) | wor_assign_referencenumber |
To external Organization, External organization responsible for handling the item. (Reference to Organization, Number 18) | ass_contr_out_org | itsm_organizations
To external Person, Employee of the external organization responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | ass_contr_out_per | itsm_persons
To person, Person made responsible for handling the item. This person will be the receiver of the assignment. (Reference to Person, Number 18) | ass_per_to_oid | itsm_persons
To workgroup, Work group of the person currently responsible for this item. (Reference to Workgroup, Number 18) | ass_workgroup | itsm_workgroups
Attached items (Set of Attached item) |  | rep_attachments ahs_att_oid
Attachment exists (Boolean, Number 1) | wor_attachment_exists |
Category, The work order's category. The category groups work orders in a hierarchical structure. In this structure work orders are grouped based on the type of work order. Click Category and select a category from the tree view. (Reference to Work order category, Number 18) | wor_cat_oid | rep_codes
Category (Service Today) (Reference to Category, Number 18) | wor_cat_oid | rep_codes
Change, Change the work order is related to. If a change is referred, you do the work order to implement the change. (Reference to Change, Number 18) | wor_cha_oid | itsm_changes
CIs Updated (Boolean, Number 1) | wor_cisupdated |
Closure code, The closure code shows the reason why the status of the work order is closed or not worked on anymore. (Reference to Work order closure code, Number 18) | wor_clo_oid | itsm_codes
Configuration items, List of configuration items. The current work order applies to the listed work orders. (Set of Configuration Item on Work order) |  | itsm_workorder_cis wci_wor_oid
Deadline, The latest date the results and work related to this item must be completed and delivered. (Date) | wor_deadline |
Description, Description of current item. The description 's a summary of the information field. The description is used for later retrieval and analyses. (Text 80) | wor_description |
Early finish, The earliest date planned that work on this item will be finalized. (Date) | wor_earlyfinish |
Early start, The earliest date planned that working on this item will start. (Date) | wor_earlystart |
Entered by person, This is used to store the person who has created this item. (Reference to Person, Number 18) | slc_wor_per_oid | itsm_persons
Estimated finish, Date and time that the item is expected to be finished. (Date) |  |
Folder, Grouping of stored items. Although all Service Desk items are stored in one database, folders may be used to identify different focus areas such as customers or customer groups. (Reference to Folder, Number 18) | wor_poo_oid | rep_codes
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
History, Work order history lines. List of changes applied to the work order's information. (Set of History line Work order) |  | itsm_historylines_workorder hwk_wor_oid
ID, Identification number. Used to identify the item when communicating information about the item. (ID, Number 18) | wor_id |
Impact, The impact reflects how much the work of the caller is impaired or in what extent the work of other people is impaired. (Reference to Impact, Number 18) | wor_imp_oid | itsm_codes
Incident, Incident the work order is related to. If an incident is referred, you do the work order to solve the incident. (Reference to Incident, Number 18) | wor_inc_oid | itsm_incidents
Information, Full information of this item. Should contain all necessary information needed to handle the item or work on the item. (Text 4000) | itsm_wor_information woi_information |
Initiator, The person who is responsible for initiating approval for this item. (Reference to Person, Number 18) | wor_initiator_per_oid | itsm_persons
Late finish, The latest date planned to finalize work on this item. (Date) | wor_latefinish |
Late start, The latest date planned to start work on this item. (Date) | wor_latestart |
Max. duration, Maximum amount of time allowed for working on the current item. (Number 9) | wor_maximumduration |
Duration, Time outage of related item(s) will last. (Number 9) | wor_occ_duration |
End Available Period (Date) | wor_occ_availableperiodend |
End Suggested Period (Date) | wor_occ_suggestedperiodend |
Outage End, Time outage of related items(s) will end (Date) | wor_occ_outageend |
Outage Start, Time outage of related items(s) will start (Date) | wor_occ_outagestart |
Planning PeriodEnd (Date) | wor_occ_planningperiodend |
Planning PeriodStart, The period in which outage should occur (Date) | wor_occ_planningperiodstart |
Start Available Period, The period with equal impact on services in which outage can occur (Date) | wor_occ_availableperiodstart |
SuggestedPeriod, The period with the least impact on related services (Date) | wor_occ_suggestedperiodstart |
Object ID (Object ID, Number 18) | wor_oid |
Open duration, Actual time the current item is opened. (Number 9) |  |
Planned Cost, Planned total cost of handling this item. (Number 64) | wor_plannedcost |
Planned Duration, Planned duration of work on this item. (Number 9) | wor_planduration |
Planned Finish, Date planned to finalize work on this item. (Date) | wor_planfinish |
Planned Start, Planned date to start working on this item. (Date) | wor_planstart |
Predecessor, Work order that has time dependencies with successor work order(s). (Set of Work order Predecessor) |  | itsm_work_order_predecessors wop_successor_wor_oid
Priority, The priority reflects the urgency for quick resolution of the item. (Reference to Priority, Number 18) | wor_pri_oid | itsm_codes
Problem, Problem the work order is related to. If a problem is referred, you do the work order to solve the problem. (Reference to Problem, Number 18) | wor_pro_oid | itsm_problems
Registered, Date and time the current item was created. (Date) |  |
Created, Date this item was created. Service Desk registered the date and time when the item was first created. You cannot edit this field. (Date) | reg_created |
Created by, Person who created this item. Or, in case of system history lines, the person who created the containing item. (Reference to Account, Number 18) | reg_created_by_oid | rep_accounts
Modified, Date the item was last modified. This date is updated by Service Desk. (Date) | reg_modified |
Modified by, Person who last modified the item. The person name is modified by Service Desk. (Reference to Account, Number 18) | reg_modified_by_oid | rep_accounts
Remain duration, Remaining duration of work on this item, calculated from the current date to the planned finish date. (Number 9) | itsm_changes cha_remainduration |
Requestor, The person who requested this item. This person is excluded from voting for approval for this item. (Reference to Person, Number 18) | wor_requestor_per_oid | itsm_persons
Service call, Service call the work order is related to. If a service call is referred, you do the work order to solve the service call. (Reference to Service call, Number 18) | wor_ser_oid | itsm_servicecalls
Source ID, Identifier for the object in the source application. This field is used by data exchange to retrieve the corresponding item in the source application. (Text 80) | wor_sourceid |
Status, Status of work order. Shows the progress of the work order towards completion. (Reference to Work order status, Number 18) | wor_sta_oid | rep_codes
Status (Service Today) (Reference to Status, Number 18) | wor_sta_oid | rep_codes
Successor (Set of Work order Predecessor) |  | itsm_work_order_predecessors wop_predecessor_wor_oid
Template (Reference to Template, Number 18) | wor_tem_oid | rep_templates
To deadline, Amount of time till deadline is reached (Number 9) |  |
Upd. CMDB status, When the status of the workorder reaches the Update CMDB Status the Planned CMDB update of this workorder will be executed. (Reference to Work order status, Number 18) | wor_updcmdb_sta_oid | rep_codes

Work Order Calculation Type (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Ordering, Ordering number for the current code. The lower the number the higher the code will be shown in lists. Once a code is used, do not modify the number. (Number 9) | cod_ordering |
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Work order category (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Attributes (Set of Attributes per category) |  | rep_attr_per_category apc_cat_oid
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Children, List of children for this code. (Set of Kernel Code Hierarchical) |  | rep_codes rcd_rcd_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Kernel Code Hierarchical, Number 18) | rcd_rcd_oid | rep_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |

Work order closure code (table: itsm_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | cod_disabled |
Children, List of children for this code. (Set of Code hierarchical) |  | itsm_codes cod_cod_oid
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | cod_icon |
Object ID (Object ID, Number 18) | cod_oid |
Parent, Name of the parent code. Select a code name from the list. By selecting a parent you create a tree view of codes. (Reference to Code hierarchical, Number 18) | cod_cod_oid | itsm_codes
Template (Reference to Template, Number 18) | cod_tem_oid | rep_templates
Text (Text 255) | itsm_codes_locale cdl_name |

Work order Predecessor (table: itsm_work_order_predecessors properties: only detail)

Description | Column | Related to
--- | --- | ---
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Object ID (Object ID, Number 18) | wop_oid |
Predecessor, Work order that has time dependencies with successor work order(s). (Reference to Work order, Number 18) | wop_predecessor_wor_oid | itsm_workorders
Successor, Work order that has time dependencies with predecessor work order(s). (Reference to Work order, Number 18) | wop_successor_wor_oid | itsm_workorders
Successor Starts As Soon As Possible (Boolean, Number 1) |  |
Successor Starts Only If Predecessor Is Closed (Boolean, Number 1) | wop_successorafterpredecessor |
Template (Reference to Template, Number 18) | wop_tem_oid | rep_templates

Work order status (table: rep_codes properties: code, cached)

Description | Column | Related to
--- | --- | ---
Blocked, Blocked check box. If selected, the code cannot be used by users. (Boolean, Number 1) | rcd_codedisabled |
Generic Incoming Relations (Set of Generic Relation) |  | ifc_genericrelations grl_to_oid
Generic Outgoing Relations (Set of Generic Relation) |  | ifc_genericrelations grl_from_oid
Icon, Icon for the code. The icon is shown in table views. Type the path and name of the icon or click Browse to find and select an icon. (Icon name, Text 255) | rcd_icon |
Kernel Code Text (Set of Kernel Code Text) |  |
Object ID (Object ID, Number 18) | rcd_oid |
Ordering (Number 9) | rcd_ordering |
Required attributes per status (Set of Required attributes per status) |  | rep_attr_per_status aps_cod_oid
State (Reference to State, Number 18) | itsm_workflow_statuses wos_sta_oid | itsm_codes
Template (Reference to Template, Number 18) | rcd_tem_oid | rep_templates
Text (Text 255) | rep_codes_text rct_name |